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-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 Above Average Values:
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 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.
Highlight Average Values (Optional):
If you want to set a color for bars with average values, add another condition.
Select "=" from the dropdown and use the same average formula
Choose a color for the bars that match the average.
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.
Comentarios