A Clustered Bar chart is a type of graph that represents data using horizontal bars. Each bar represents a different category or group, and the length of the bar corresponds to the value it represents. Clustered Bar charts display multiple data series side by side for each category, making it easy to compare values across different groups.
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 “Build visual pane“ that we want to compare and analyze.
Y axis: represent categories – Continent
X axis: Shows the values – Medal Count
Legend: Legend: Explains the groups in the clustered bar chart– Medal
Step 4
Filters in a clustered 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, Colors and Data labels. Click anywhere on the visual and set the below properties in the Format visual pane.
In this visual, I chose background color as blue and gave 87% transparency which reduces the intensity of the color.
Gave suitable title for the visual and customize 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 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. Save the Power BI report to preserve the visual and its formatting.
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 a Clustered bar chart can be used effectively:
- Comparing multiple metrics or data series across different categories.
- Comparing categories with long category names.
Pros
- 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.
Cons
- 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.
Conclusion
Bar charts are a user-friendly and popular way to visualize data. They effectively display comparisons and patterns, making complex information easier to understand. Whether you're examining sales figures, survey results, or other data with clear categories, bar charts are a valuable tool for presenting information clearly.
Useful Information
| Tags | Power BI |
| Useful links | https://www.geeksforgeeks.org/power-bi-format-clustered-bar-chart/ |
| MS Learn Modules | https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-column-charts |
| Test Your Knowledge | Quiz |
No comments:
Post a Comment