Format Rule: Icon Ranges

Icon “Ranges” allow you to use predefined or custom sets of icons to apply conditional formatting to different ranges of values:

For example, let us select the 4-range highlight for the “Gross Profit” measure:

The following options are available in the appeared window:

• Format style – the “Format Style” combo box allows you to change the icon set used to apply formatting;
• Use % ranges – the “Use % ranges” check box specifies whether the percent or absolute scale is used to generate ranges;
• Range field with set values:

Use the «Add» and «Delete» buttons to add new ranges or delete the selected range respectively. Note that new range is added below the selected range:

To change the icon displayed for values corresponding to the specified range, click the button next to the required icon and select a new icon:

• Intersection mode – the level at which the highlight will be The levels can be as follows:
  • Auto – identifies the default level. For the Pivot dashboard item, “Auto” identifies the “First Level”;
  • First level – first level values are used to apply conditional formatting;
  • Last level – the last level values are used to apply conditional formatting;
  • All levels – all pivot data cells are used to apply conditional formatting;
  • Specific level – values from the specific level are used to apply conditional
• Row/Column dimension – if you specified the Intersection mode as “Specific Level”, use the “Row dimension” and “Column dimension” combo boxes to set the specific level;
• Apply to – to which element (measure, hierarchy) of the Pivot table the conditional formatting should be applied;
• Apply to row/column – apply to the entire row / to the entire

Fill in the form with the following data:

As a result, the pivot table will look the following: