Conditional Formatting
Last updated
Last updated
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.
Conditional Formatting is exclusively available in Hierarchy View Mode. It is not available in Facet view or Date mode.
If the visual is already in Hierarchy View, Conditional Formatting is enabled by default.
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.
In the Format Pane, you can customize Conditional Formatting using the following three options:
Icon Color: Customize the icon's color based on conditions.
Background Color: Highlight cells with specific background colors.
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.
For further details, you can refer to the Microsoft Conditional Formatting Documentation.
