Format Rule: Bar Color Range

“Bar Color Ranges” allow you to visualize numeric values using bars whose colors are contained in the specified color set:

This dialog allows you to change the following options specific to “Bar Color Ranges”:

The following options will be available in the appeared window:

• Format style – the “Format Style” combo box allows you to change the color 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 specifies 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 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 column;
• Allow negative axis – the “Allow negative axis” option allows you to specify whether negative data bars are displayed in the direction opposite to the positive data bars;
• Draw axis – the “Draw axis” option specifies whether to draw the vertical axis between positive and negative data bars;
• Show bar only – the “Show bar” only option specifies whether to show bars without corresponding values.