The requested page is not available for the requested platform. You are viewing the content for Default platform.

Value

The Value format condition allows you to compare dimension/measure values with static values (such as Greater Than, Less Than, Between, etc.).

The following condition types are supported for measures or date-time dimensions.

Format Condition

Description

Can be applied to

Greater Than/Greater Than or Equal To

The Greater Than/Greater Than or Equal To format conditions allow you to apply formatting to elements whose values are greater than/greater than or equal to the specified value. For instance, the following image displays a Grid dashboard item whose Extended Price cells are filled in green if their values are Greater Than 150 000.

GreaterThanCondition

Measures or date-time dimensions

Less Than/Less Than or Equal To

The Less Than/Less Than or Equal To format conditions allow you to apply formatting to elements whose values are less than/less than or equal to the specified value. For instance, the following image displays a Grid dashboard item whose Extended Price cells are filled in red if their values are Less Than 150 000.

LessThanCondition

Measures or date-time dimensions

Equal To/Not Equal To

The Equal To/Not Equal To format conditions allow you to apply formatting to elements whose values are equal to/not equal to the specified value. For instance, the following image displays a Grid dashboard item whose Sales Person cells are filled in blue if their values are equal to 'Robert King'.

EqualToCondition

Measures, string or date-time dimensions

Between/Not Between

The Between/Not Between format conditions allow you to apply formatting to elements whose values are between/not between the specified values. For instance, the following image displays a Grid dashboard item whose Extended Price cells are filled in orange if their values are Between 100 000 and 200 000.

BetweenCondition

Measures or date-time dimensions

Text That Contains

The Text That Contains format condition allows you to apply formatting to elements whose values contain the specified text. For instance, the following image displays a Grid dashboard item whose Sales Person cells are in cyan if their values contain the 'An' text.

TextContainsCondition

Measures, string or date-time dimensions

To create the Value format condition in code, create the FormatConditionValue class instance and specify the following settings.

Assign the resulting FormatConditionValue object to the DashboardItemFormatRule.Condition property.

How to: Apply Conditional Formatting to Grid Cells using the Value Format Condition