Highlight Bars with Above/Below Average Values in a Column Chart

[harikm007]

In this guide, we’ll explore how to highlight bars with values above or below the average in a column chart using Sisense's built-in features. As you may have already seen, we can also highlight min and max values in a line chart using a script. Now, let’s dive into the steps for making your column charts even more informative!

Step 1: Create Your Column Chart

Start by creating a column chart. Add your desired Categories and a Measure; for example, you select "Age Range" as your category and SUM(Quantity) as your measure.

Step 2: Access the Color Selector

Next, access the color selector in the Measure panel, which opens a popup window. In this popup, you’ll find three options: Single Color, Range, and Conditional. Click on the Conditional tab to proceed.

Step 3: Configure Conditional Colors

In the Conditional tab, you can set conditions and corresponding colors for your bars.

Highlight Above Average Values:

• Remove all conditions that are loaded automatically except the first condition.

• Select ">" from the dropdown..

• Click on the Formula option and enter the formula to calculate the average

avg([Age Range], sum([Quantity]))

• Choose a color for the above average values.

Highlight Below Average Values:

• Add another condition for the lowest value.

• Select "<" from the dropdown and use the same average formula

avg([Age Range], sum([Quantity]))

• Select a distinct color for the lowest value.

Step 4: Apply Your Changes

Once you’ve configured the conditions, click OK to apply your changes. Your column chart will now display bars representing values above and below the average in different colors, allowing for quick identification of performance against the average.

See below post to find more detailed steps: https://www.binextlevel.com/post/highlight-bars-with-above-below-average-values-in-a-column-chart-1 

Also see how to highlight Min and Max bars in a column chart: https://www.binextlevel.com/post/how-to-highlight-max-and-min-bars-in-a-column-bar-charts 

-Hari

https://www.binextlevel.com/ 

[DRay]

Very nice @harikm007, thank you for writing this up!