6. Conditional Formatting

Applicable in: ☑️Date Filter ❌Facet Filter ✔️Hierarchy Filter ❌Alpha Numeric Filter

❌Numeric Filter

Conditional Formatting allows you to apply colors to items in the visual based on specific criteria, helping to highlight key insights or trends in your data.

How to enable Conditional Formatting

1. Conditional Formatting is exclusively available in Hierarchy Filter & Date Filter (Month Range & Month). It is not available in Facet view or Date mode (Multi Year, Year, Week, Day).

2. If the visual is already in Hierarchy View, Conditional Formatting is enabled by default.

3. If Hierarchy View is not enabled, you can enable it via the Format Pane:

   • Navigate to the Format Pane.

   • Enable Hierarchy View to activate Conditional Formatting.

Image 1: Conditional Formatting in Hierarchy Filter.

How to Customize Conditional Formatting

In the Format Pane, you can customize Conditional Formatting using the following three options:

1. Icon Color: Customize the icon's color based on conditions.

2. Background Color: Highlight cells with specific background colors.

3. Font Color: Change the font color to emphasize specific data points.

To set up these options, use the Fx button in the Format Pane, which allows you to define the conditions and formatting rules.

Image 2: Conditional Formatting settings in Format pane

For further details, you can refer to the Microsoft Conditional Formatting Documentation.