Format Rule: Bar

The “Bar” format condition allows you to visualize numeric values using bars. You can also paint bars corresponding to positive and negative values using different colors:

This dialog allows you to change the following options specific to the “Bar” format condition:

• Min/Max – by default, lengths of the shortest and longest bars correspond to minimum and maximum values, respectively. If necessary, you can specify values corresponding to the shortest and longest bars manually. To do this, change the type of minimum/maximum value from “Automatic” to “Number or Percent”, and specify the required values;
• Style Settings – “Style Settings” and “Negative Style Settings” allow you to specify style settings used to color data bars corresponding to positive and negative values, respectively;
• 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.

Let us look at this type of highlight on the example of the “Pivot” table:

Let us add a highlight rule for the “Reseller Gross Profit” measure:

Fill out the form as follows:

As a result, we will get the following table: