How to Highlight Max and Min Bars in a Column/Bar Charts

In this guide, we'll explore how to highlight the maximum and minimum bars in a column chart using Sisense's built-in features. As you may have already seen, we can highlight min and max values in a line chart using a script . Now, let’s dive into the steps for enhancing your column charts with eye-catching visual indicators for key data points!

Step-by-Step Guide

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 the Maximum Value:

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

• Select "=" from the dropdown.

• Click on the Formula option and enter the formula to find the highest value. in our case the formula is :

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

• Choose a color for the highest value.

Highlight the Minimum Value:

• Add another condition for the lowest value.

• Enter the formula for the lowest value

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

• Select a distinct color for the lowest value.

Set Color for Remaining Bars:

• Select "Not Equal To" from the dropdown.

• Use the formula for the highest or lowest value again to define the color for all other bars.

Step 4: Apply Your Changes

Once you’ve configured all your conditions, click OK to apply your changes. Your column chart will now display bars representing the highest and lowest values in different colors, allowing for quick identification of key data points.