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

Conditional Formatting

  • 2 min to read

The Grid dashboard item supports the conditional formatting feature that provides the capability to apply formatting to grid cells whose values meet the specified condition. This feature allows you to highlight specific cells or entire rows using a predefined set of rules. To learn more about conditional formatting concepts common for all dashboard items, see Conditional Formatting.

wdd-grid-conditional-formatting

The Grid dashboard item allows you to apply conditional formatting to data items providing data to the dimension and measure column types.

You can use hidden measures to specify a condition used to apply formatting to visible values. New appearance settings are applied to grid cells corresponding to the target dimension/measure values.

Create and Edit Format Rules

To create a new format rule, select the required measure / dimension by whose values a format condition will be calculated, open its menu and go to the Conditional Formatting section. Click "+" to add a new rule.

wdd-grid-cf-add-rule

Then, specify the data item to which conditional formatting is applied using the Apply to combo box and select the condition type. To see the list of available format conditions, go to Conditional Formatting.

wdd-grid-cf-select-rule-type

Depending on the selected format condition, the menu used to create a format rule for a Grid contains different settings. For example, the image below displays the Value format condition menu. Here you need to specify a required value and select a format rule style.

wdd-grid-cf-value-menu

Note

The Miscellaneous section of the format rule menu contains additional settings, depending on the dashboard item type. The Grid dashboard item allows you to apply the current format rule to a row or disable this rule.

The format condition is now ready and will be applied to the Grid dashboard item.

wdd-grid-conditional-formatting-result

To edit a format rule, open the Conditional Formatting section of the data item menu, select the required format rule and click the Edit button (the wdd-icon-edit-collection-value-item icon).

wdd-grid-cf-edit-rule

To delete the selected format rule, click the Delete button (the wdd-icon-delete-big icon).