Lesson 26 - Clustered Column Chart in Power BI Desktop

A clustered column chart is a type of graph that represents data in vertical bars. Each column represents a different category or group, and the height of the column corresponds to the value of the data it represents.

How to proceed?

Step 1: Import the Data

Launch Power BI Desktop, create a new report page, and import the required data.

Refer Lesson 7 - Power BI Semantic Model to build great visuals

Step 2: Add a Clustered Column Chart

From the Visualizations pane, select the Clustered column chart visual highlighted in the figure.

Step 3 Add Fields to the Clustered Column Chart

Add the required fields to the appropriate field wells in the Build visual pane:

X-axis – Region and Medal

Y-axis – Medals

Legend – Medal

The X-axis represents the categories displayed in the chart.

The Y-axis displays the numerical values.

The Legend groups the columns into different data series.

Step 4 Apply Filters

Filters allow you to focus on specific data in the Clustered column chart, making the visual easier to analyze.

In this example, the Medal field is filtered to display only Gold, Silver, and Bronze medals. A Top N filter is also applied to the Region field to display the top 7 regions based on medal count.       

Using the Filters pane, you can focus on the top 7 regions based on medal count and compare the Gold, Silver, and Bronze medals won by each region. This makes it easier to analyze and compare the medal achievements of the top-performing regions in the Olympic Games.

Step 5 Customizing the appearance of clustered column chart

You can customize the appearance of the visual. You can change the title, font size, colors, columns, and data labels. Click anywhere on the visual and set the below properties in the Format visual pane.

Refer Lesson 6 - Formatting the visuals in Power BI Desktop

In this demo, I chose background color as blue and gave 87% transparency which reduces the intensity of the color.

I added a suitable title to the visual and customized the font size, color, and position of the title.

Chose colors for the vertical bars to show different categories.

To add data labels to the column chart, click on the “Data Labels” section under

“Visual”. Here you can choose which data to display in the labels and adjust their position, font, and color.

In this demo, I chose to display All data labels in Horizontal orientation and set the position to Outside end, which displays the values above each column.

Step 6

Save the visual

Finally, your Clustered column chart is ready. Save the Power BI report to preserve the visual and its formatting.

When to use Clustered column chart?

You can use Clustered column charts to compare data points within discrete categories or display multiple data series side by side. Here are some scenarios when to use clustered column chart effectively.

• Analyzing time series data for categorical variables
• Comparing multiple metrics for different categories

Pros

• Clustered column chart allows users to compare multiple data series side by side. This makes it easy to see patterns and trends in the data.
• It helps users to group data based on categories, allowing them to logically organize and present information.
• Best suits for explaining categorical data with distinct groups.
• Clustered column charts enhance the visual appeal of reports and presentations, making them more engaging for the audience.

Cons

• Using clustered column charts to handle time series data may not be the most effective approach.
• When the differences between data points are small, it can be challenging to visually compare the heights of the columns accurately.
• When dealing with large number of categories, the chart becomes crowded and difficult to read.
• They might not be ideal for representing continuous data with wide range of values.

Conclusion

Column charts are a user-friendly and popular way to visualize data. They effectively display trends, comparisons, and patterns, making complex information easier to grasp. Whether you're examining sales figures, survey results, or any data with clear categories, column charts are a valuable tool to present information clearly.

Useful Information

Tags	Power BI
Useful links	Clustered column chart in Power BI - Power BI Docs
MS Learn Modules	https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-column-charts
Test Your Knowledge	Quiz