Conditional Formatting

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

wdd-pivot-cf

The Pivot dashboard item allows you to use conditional formatting for measures placed in the Values section and dimensions placed in the Columns/Rows sections.

You can use hidden measures to specify a condition used to apply formatting to visible values. New appearance settings are applied to data cells corresponding to a row/column intersection. You can set the intersection of the row and column manually or use predefined settings.

Create and Edit Format Rules

To create a new format rule for the Pivot's dimension/measure, select the required data item 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-pivot-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-pivot-cf-select-rule

Depending on the selected format condition, the menu used to create a format rule for Pivot contains different settings. For example, the image below displays the Top/Bottom format condition menu. Here, you need to specify the number of values to be displayed and select a format rule style.

wdd-pivot-cf-top-n-menu

The Miscellaneous section of the format rule menu contains additional settings depending on the dashboard item type. The Pivot dashboard item allows you to manually specify an intersection level or disable the current rule.

Note

The dashboard does not provide the capability to calculate conditional formatting in the pivot grid for multiple levels for ranges with percentage values. In this case, the "All Levels" intersection mode is missing for a conditional formatting rule.

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

wdd-pivot-cf-applied-rule

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-pivot-cf-edit-rule

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