Comparison rules used in conditional formatting can be divided into the following groups, which also includes the data items that are supported by each group:
|
Group |
Description |
Supported Data Items |
|---|---|---|
|
Value |
Used to compare static values using operators such as Greater Than, Less Than, Between, etc. See Value. |
Measure/Numeric dimension, String dimension (with condition type set to Equal To, Not Equal To, or Text that Contains Expression), Date-Time dimension |
|
Top-Bottom |
Used to highlight a specific number of topmost/bottommost values. See Top-Bottom. |
Measure/Numeric dimension |
|
Average |
Used to highlight values above and below an average. See Average. |
Measure/Numeric dimension |
|
A Date Occurring |
Used to highlight date-time values within a specified interval. See A Date Occurring |
Date-Time dimension |
|
Expression |
Used to apply formatting using complex conditions. You can also pass dashboard parameters to expressions. See Expression. |
Measure/Numeric dimension, Date-Time dimension |
|
Icon Ranges |
Used to apply formatting by displaying specific icons for different ranges of values. You can select a predefined set of icons or use a specific icon for each range. See Icon Ranges. |
Measure/Numeric dimension, Date-Time dimension |
|
Color Ranges |
Used to apply formatting using specific colors for different ranges of values. You can select a predefined set of colors or use custom appearance settings to highlight values within specified ranges. See Color Ranges. |
Measure/Numeric dimension, Date-Time dimension |
|
Gradient Ranges |
Used to apply formatting using gradient color scales. See Gradient Ranges. |
Measure/Numeric dimension, Date-Time dimension |
|
Bar |
Used to visualize numeric values using bars. You can also color bars corresponding to positive and negative values using different colors. See Bar. |
Measure/Numeric dimension, Date-Time dimension |
|
Bar Color Ranges |
Used to visualize numeric values using bars whose colors are contained in a color set containing a specified number of colors. See Bar Color Ranges. |
Measure/Numeric dimension, Date-Time dimension |
|
Bar Gradient Ranges |
Used to visualize numeric values using bars whose colors selected from a specified color gradient. See Bar Gradient Ranges. |
Measure/Numeric dimension, Date-Time dimension |