Skip to main content
All docs
V24.1

Conditional Formatting

  • 2 minutes to read

Use conditional formatting to highlight individual cells or rows based on specific conditions. You can apply format rules to dimension and measure column types.

You can use hidden measures to specify a condition used to format visible values.

Web Dashboard - Grid Dashboard Item - Conditional Formatting

Supported Condition Types

Available condition types depend on the data item type. The table below lists data types and their supported condition types:

Data Type

Supported Condition Types

numeric

Value

Top-Bottom

Average

Expression

Icon Ranges

Color Ranges

Gradient Ranges

Bar

Bar Color Ranges

Bar Gradient Ranges

string

Value with the condition type set to Equal To, Not Equal To or Text that Contains

Expression

date-time

Value

A Date Occurring for dimensions with the continuous date-time group interval

Expression

Icon Ranges

Color Ranges

Gradient Ranges

Bar

Bar Color Ranges

Bar Gradient Ranges

Refer to the following topic for more information about format condition types: Conditional Formatting Basics

Create and Edit a Format Rule

To create or edit a format rule, open the Conditional Formatting section in the data item menu or in the dashboard item’s Options menu. Click + to add a new format rule:

Web Dashboard - Add or Edit a Format Rule

Refer to the following topic for more information on how to create and edit format rules: Conditional Formatting in Web Dashboard

Appearance Settings

You can add an icon to the cells/rows or configure the style for display text or background color. To do this, open the format rule’s Condition section and specify the settings:

Appearance

You can select a predefined style or create a Custom Style in the Appearance tab. You can specify the background color, the text color, and the font settings.

Web Dashboard - Appearance Tab

Icons

You can select an predefined icon from the Icon tab.

Web Dashboard - Icons Tab

Grid-Specific Format Condition Settings

In the format rule’s Miscellaneous section, you can specify the following settings:

Web Dashboard - Grid Conditional Formatting - Miscellaneous Section

Option Description
Enabled Enables/ Disables the current format rule.
Applied to Row Applies the current format rule to a row.