Skip to main content

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

  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 the met, the colors of the arcs will change.

                       

note

You can re-order, edit or delete existing rules.

If two rules are true for the same arc. The color of the rule at the top of the list will be applied.

Tutorial

Gif

Measure Rule

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 by equal to, not equal to, less than, greater than, less than equal to, greater than equal to, and between.

Category Rule

You can set rules based on 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.