Average

The Average format conditions allow you to highlight values above or below an average value.

The following condition types are supported for measures:

• Above Average/Above or Equal Average

  The “Above Average”/”Above or Equal Average” format conditions allow you to apply formatting to elements whose values are above/above or equal to the average. For instance, the following image displays a Grid dashboard item whose Extended Price values that are above average (~ 141 000) filled in green.

  

• Below Average/Below or Equal Average

  The “Below Average”/”Below or Equal Average” format conditions allow you to apply formatting to elements whose values are below/below or equal to the average. For instance, the following image displays a Grid dashboard item whose Extended Price values that are below average (~ 141 000) filled in red.