In this blog, you will learn how to create a clustered column chart in Power BI. It is a tool that visually compares multiple data categories across different subcategories.
Introduction to clustered column chart in PowerBI
A clustered column chart is a type of bar chart that groups multiple data series in clusters for each category. Each cluster represents a different category, and within each cluster, individual bars represent different subcategories. This chart type is particularly effective for comparing multiple datasets across several categories, making it easier to identify trends and differences.
Clustered column charts are commonly used in business and data analysis to visualize comparisons between groups and track changes over time. They provide a clear and straightforward way to present complex data in an easily interpretable format.
Dataset description
We will use a supermarket sales dataset for this tutorial. This dataset has information about transactions such as the invoice ID, branch, city, customer type, gender, product line, unit price, quantity, tax, total amount, sale date and time, payment mode, cost of goods sold (COGS), gross margin percentage, gross income, and buy rating. This dataset gives you a lot of information about sales events, which makes it perfect for making a clustered column chart in PowerBI.
You can access the dataset here.
Description: In this dataset, there following features/columns:
| Invoice ID | Unique Identifier for each Invoice |
| Branch | There are four branch Site |
| City | City where transactions occurred |
| Customer Type | Type of Customer – Member or Normal |
| Gender | Gender – Male, Female |
| Product Line | Type of Product |
| Unit Price | Price of a Single Unit of Product |
| Quantity | Total Quantity of Product Sell in a Single Purchase |
| Tax 5% | 5% of Tax on Cost of Goods Sold |
| Total | Total Amount of Items without Tax |
| Date | Date of Sale |
| Time | Time of Sale |
| Payment | Mode of Payment |
| COGS (Cost of Goods Sold) | Total Amount of Items with Tax |
| Gross Margin Percentage | Total Profit in Percentage |
| Gross Income | Total Profit |
| Rating | Raing of the purchase in range of 1-10 |
Data Sample:
Procedure to Create Clustered Column Chart in PowerBI:
Step1: Open your PowerBI Desktop on your Device
Step2: Click on Get Data button in Home Ribbon and select Text/CSV.
Step3: Open Prompt box will be open to select your text or csv file.
Step4: After selection of dataset, It will pop up a window for Load OR Transform Data. Click on Load to use data on PowerBI.
Step5: In the following picture, data has been loaded successfully.
Step6: Select Clustered Column Chart from Visualizations Section (Right Hand Side).
Step7: Here, we’ll put the following data (from supermarket_sales) in different fields:
| X-axis | Gender |
| Y-axis | Quantity (Sum of Quantity) |
| Legend | Customer type |
After that you have to click on format your visual. Go to the General click on turn on visual border and the shadow. In the Visual border make the rounded corner of 15 px.
What the Chart indicating
The chart shows that female customers purchased more products overall (2869 units) compared to male customers (2641 units). Among both genders, normal users bought slightly more than member users. Specifically, normal users purchased 1377 units (female) and 1348 units (male), while member users bought 1492 units (female) and 1293 units (male).
Conclusion
With a clustered column chart, we can view our categorical and numeric data as columns and create a side-adjacent column of another categorical or numeric data. We can get the details of each column by moving the cursor over the column as a tooltip.
You can tell your friends or coworkers about this blog if you like it. There are social media sites like LinkedIn, Twitter, and Instagram where you can find me.
🔔 Follow Me: LinkedIn| Youtube | Instagram | Twitter
👏 Like for this article and subscribe to our newsletter
📰 View more content on my DataSpoof website
