Friday, December 29, 2023

Lesson 29 - Clustered Bar Chart in Power BI Desktop

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

How to Proceed?

Step 1
Launch power BI desktop app and open the new report page and import the data required. 

Step 2
In “visualizations” pane click on “clustered bar chart” which is highlighted in the given figure.

Step 3
Drag the data fields into “Field Section “that we want to compare and analyze. 

Y axis:  represent categories – Continent

X axis: Shows the values – Medal Count

Legend: Explain the groups in clustered column chart – Medal

Step 4

Filters in 100% stacked bar chart enable users to selectively focus on specific categories or subcategories of data for deeper analysis.

Here I applied basic filter eliminating NA in continent and for Medals eliminated No medal category

Step 5

Customizing the appearance of clustered bar chart
You can customize the appearance of the visual.  You can change Title, Font size, Style, Colours and Data labels. Click anywhere on the visual and set the below properties in the Format section.

In this visual, I chose background colour as blue and gave 87% transparency which reduces the intensity of the colour. 
Gave suitable title for the visual and customize the font size, colour and position of the title.

Chose colours for the vertical bars to show different categories.

To add data labels to the bar 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 visual, I chose to display “All” data labels are placed outside at the end which shows the values on each bar. 

Step 6 Save the visual

Finally, your Clustered bar chart is ready. Click save button to save the visual.

When to use Clustered bar chart?

You can use Clustered bar charts to compare data points within discrete categories or display multiple data series side by side. Here are some scenarios when to use clustered bar chart effectively
  • Analyzing time series data for categorical variables
  • Comparing multiple metrics for different categories
  • Clustered bar 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 bar charts enhance the visual appeal of reports and presentations, making them more engaging for the audience.

  • Using clustered bar 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.


Bar 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.

Tags Power BI
Useful links
MS Learn Modules
Test Your Knowledge Quiz

No comments:

Post a Comment