Conditional Formatting

Conditional formatting lets you color code specific words based on a set of rules. You can create rule based on category or measure data.

Steps to apply conditional formatting?

  1. Go to conditional formatting, using advanced settings.

  2. Click on the “Add Rule” button. [Rule name is mandatory to have.]

  3. Apply rule to the measure or category.

  4. Pick to column from the dropdown menu.

  5. Create a condition and select the custom color.

  6. Hit save, to apply.

Result: If the conditions are the met, the colors will be visible on the word cloud.

IMAGE – ABOUT STEPS ON HOW TO APPLY CONDITIONAL FORMATTING

Measure Rule

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

Category Rule

You can set rules based on dimension in this section. 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.

Note: When there is no measure added into measure filed, then in that case you can only apply conditional formatting based on Category is present.

Last updated