Dashboard Designer > Appearance Customization > Conditional Formatting

Format Rules

Comparison rules used in conditional formatting can be categorized as follows:

Value - Compares static values (Greater Than, Less Than, Between, etc.).

Top-Bottom - Highlights a specific number of top/bottom values (Top N, Bottom N).

Average - Highlights values above or below the average value.

A Date Occurring - Highlights date-time values that are within a specified interval.

Expression - Uses complex conditions to apply formatting. You can also pass dashboard parameters to expressions.

Icon Ranges - Display a specific icon based on a value range. You can select a predefined set of icons or apply a specific icon to each range.

Color Ranges - Apply specific colors to different value ranges. You can select a predefined set of colors or use custom appearance settings to highlight values within specified ranges. Gradient Ranges - Apply formatting using gradient color scales.

Bar - Visualizes numeric values as bars. You can also color bars corresponding to positive and negative values using different colors.

Bar Color Ranges - Visualize numeric values as bars. Values within a range display a specific color.

Bar Gradient Ranges - Visualize numeric values as bars. Values within a range display a specific bar gradient.

Format conditions that can be applied to different data item types are as follows:

numeric

Value

Top-Bottom

Average

Expression

Icon Ranges

Color Ranges

Gradient Ranges

Bar

Bar Color Ranges

Bar Gradient Ranges

Value (with a condition type set to Equal To, Not Equal To or Text that Contains) Expression

date-time