Conditional Formatting

The Web Dashboard control allows you to format dashboard item elements whose values meet a specified condition. This feature allows you to highlight specific elements using a predefined set of rules.

To learn more about the specifics of using a conditional formatting feature for different dashboard items, see the following topics.

wdd-cf-main

Format rules used in conditional formatting can be divided into groups depending on their purpose and can be applied to measure or dimension values. To read about available format rules, see Conditional Formatting.

Create and Edit a Format Rule

To create a format rule, perform the following steps.

  1. Select the required measure/dimension by whose values a format condition will be calculated, open the Conditional Formating section of the data item menu and click "+" to add a new format rule.

    wdd-grid-cf-add-rule

  2. Specify the data item to which conditional formatting is applied using the Apply to combo box and select a condition type from the list.

    wdd-grid-cf-select-rule-type

  3. The format rule's menu is opened. This menu depends on the selected format condition and the type of the dashboard item. Here you can specify settings specific for the selected condition. For example, the Value format rule allows you to set a value that will be compared with dimension/measure values and specify a format rule style. The image below displays settings where values greater than 300M will be colored in pale green.

    wdd-grid-cf-value-menu

    You can specify additional settings in the Miscellanous section of the format rule's menu. This section contains settings depending on the type of the dashboard item. For example, you can manually specify an intersection level for the Pivot or apply the current rule to a row in the Grid.

  4. The format rule is now ready and will be applied to the 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). To delete the selected format rule, click the Delete button (the wdd-icon-delete-big icon).

wdd-grid-cf-edit-rule

You can see existing format rules for the entire dashboard item. To do this, open the dashboard item's Options menu and go to the Conditional Formatting section.

wdd-cf-all-rules

Appearance Settings

When creating a new format rule, you can select the required appearance settings in the Condition section of the format rule's menu. This settings applied according to the current format condition. All format conditions allow you to customize appearance settings in a similar manner.

For example, the Value format condition allows you to specify appearance settings in the following way...

  • The Appearance tab allows you to choose the predefined background color or font.

    wdd-cf-appearance-gallery

  • The Icons tab allows you to add the predefined icon.

    wdd-cf-icons-gallery

... while the different types of Range format rules allow you to customize predefined range colors and values.

wdd-cf-range-gallery