Conditional Formatting

  • 2 minutes to read

The Web Dashboard control supports conditional formatting. You can apply a custom style to data elements that satisfy a certain condition for Grid, Pivot, Chart, Scatter Chart, and Cards items.

wdd-cf-main

Format Rules

Refer to the Conditional Formatting Basics topic for information about the format rules that can be applied to different data item types.

Create a Format Rule

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

wed-dashboard-cf-add-rule

Specify the data item/card used to calculate a condition in the Common section. You can create a format rule that uses values from one item but applies the style settings to a different item.

Select a format rule type from the list to open its settings.

wdd-grid-cf-select-rule-type

Select a condition from the list and specify its settings in the Condition section. Available settings depend on the selected format rule.

wdd-grid-cf-value-menu

Specify additional settings in the Miscellaneous section. For example, you can specify an intersection level for a Pivot or apply a rule to a row in a Grid.

Edit a Format Rule

To edit a format rule, select the rule and click Edit (wdd-icon-edit-collection-value-item).

wdd-grid-cf-edit-rule

Click Delete (wdd-icon-delete-big) to delete the selected format rule.

When you edit a format rule, you can enable or disable the rule in the Miscellaneous section.

Other settings in the Miscellaneous section depend on the selected dashboard item.

Appearance Settings

The format rule's Condition section contains appearance settings.

For Grid, Pivot, and Card items, you can configure and customize the current format condition appearance settings:

  • Choose a predefined background color or font in the Appearance tab.

    wdd-cf-appearance-gallery

  • Add a predefined icon in the Icons tab.

    wdd-cf-icons-gallery

Chart and Scatter Chart items have a predefined palette and a custom palette. Click a color chip in the Custom Color palette to set a new custom color. You can pick any color using the RGB or HSB color model in the invoked color picker.

You can change generated colors for the Range format rules as well:

wdd-cf-range-gallery

Dashboard Items Specific

See the following sections for more information about specific format settings for dashboard items: