# Conditional Formatting

Conditional formatting lets you **change the color of arcs based on rules**. You can create multiple rules based on the category or measure fields.

### Steps to apply conditional formatting[​](https://docs.powerviz.ai/sunburst/advanced-settings/conditional-formatting#steps-to-apply-conditional-formatting) <a href="#steps-to-apply-conditional-formatting" id="steps-to-apply-conditional-formatting"></a>

1. Go to conditional formatting, using advanced settings.
2. Click on the “**Add Rule**” button.
3. Rule name is mandatory to have.
4. Apply a rule by **measure or category**.
5. Pick the column from the drop-down menu.
6. Create a condition and **select** the custom color.
7. Hit **Save**, to apply.

Result: If the conditions are met, the colors of the arcs will change.

<figure><img src="https://powerviz-assets.s3.us-east-2.amazonaws.com/docs/doc-sunburst/45.png" alt=""><figcaption></figcaption></figure>

{% hint style="info" %} <mark style="color:blue;">INFO</mark>

* <mark style="color:blue;">You can re-order, edit, or delete existing rules.</mark>
* <mark style="color:blue;">If two rules are true for the same arc. The color of the rule at the top of the list will be applied.</mark>
  {% endhint %}

#### Tutorial[​](https://docs.powerviz.ai/sunburst/advanced-settings/conditional-formatting#tutorial) <a href="#tutorial" id="tutorial"></a>

![Gif](https://powerviz-assets.s3.us-east-2.amazonaws.com/docs/doc-sunburst/60.gif)

### Measure Rule[​](https://docs.powerviz.ai/sunburst/advanced-settings/conditional-formatting#measure-rule) <a href="#measure-rule" id="measure-rule"></a>

You can set rules based on any numeric value in this section. **Measure field and tooltip** aggregated values can be used to apply conditions. Measure rules can be defined as equal to, not equal to, less than, greater than, less than equal to, greater than equal to, and between.

<figure><img src="https://powerviz-assets.s3.us-east-2.amazonaws.com/docs/doc-sunburst/46.png" alt=""><figcaption></figcaption></figure>

### Category Rule[​](https://docs.powerviz.ai/sunburst/advanced-settings/conditional-formatting#category-rule) <a href="#category-rule" id="category-rule"></a>

You can set rules based on the **dimension** added in the Category field. Select the hierarchy level and type the exact text of the node you wish to highlight. For categories, rules can be set by is, is not, begins with, does not begin with, ends with, does not end with, contains, does not contain.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.powerviz.ai/powerviz/sunburst/advanced-settings-introduction/conditional-formatting.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.