Conditional Formatting

Conditional formatting is used only when the specified condition is satisfied. Conditional formatting makes data analysis more visual.

NOTE. Setting up conditional formatting for the Reports tool is available only in the desktop application.

Conditional formatting can be applied to several table elements and can consist of several conditions, for example:

There are the following approaches to conditional formatting setup:

Elements for Conditional Formatting

Conditional formatting can be available for the following elements:

Dimension element (row/column).
Calculated element.
Level.
Dimension.
Entire table (data).
Column totals.
Row totals.

Order of Conditional Formatting Application

Settings of different conditional formatting types (color schemes, color scales, icons, histograms) overlap each other. If table elements have identical formatting type, settings are applied in the following order:

Entire table (data).
Dimension.
Level.
Dimension element.
Calculated element.

Features of Conditional Formatting Application

There are the following features on using conditional formatting:

Conditional formatting overlaps table style.
Conditional formatting determined for calculated elements (calculated hierarchy) or alternative hierarchy is more important than conditional formatting determined for dimension elements.
Conditional formatting of row totals (displayed in the column) is more important than column totals (displayed in the row).
If conditional formatting in the row overlaps the conditional formatting in the column, the conditional formatting by column is applied. This rule is applied equally to other table elements.
If several dimensions are located in heading or sidehead, for which conditional formatting is set, the higher importance is given to elements of the last dimension located in the heading or sidehead. This rule is applied equally to other table elements.
Conditional formatting is applied according to the selected measurement unit.