Power BI Clustered Column Chart is used to display vertical bars of multiple data regions (Measures) against single Metric. In this article we will show you, How to Create Clustered Column Chart in Power BI with example.
For this demonstration we are going to use the SQL Data Source that we created in our previous article. So, Please refer Connect Power BI to SQL Server article to understand the Data Source.
How to Create a Clustered Column Chart in Power BI
First, click on the Clustered Column Chart under the Visualization section. This will automatically create a Clustered Column Chart with dummy data as shown in the below screenshot.
In order to add data to Clustered Column Chart, we have to add required fields:
- Axis: Please specify the Main Column that represent the Verical Axis.
- Legend: Specify the second Column that represent Vertical Bars (or bar colors).
- Values: Any Numeric value such as sales amount, Total Sales etc.
Let me drag the Sales Amount from Fields section to Values field
Next, let me add English Country Region Name to Axis section to create a Column Chart. This Chart shows the Sales Amount by English Country Region Name.
Next, add English Occupation from DimCustomer table to the Legend section.
Create a Clustered Column Chart in Power BI – Approach 2
In order to create a Clustered Column Chart, first Drag and Drop the Sales Amount from Fields section to Canvas region. This will automatically create a Column Chart as we shown in below.
Next, let me add English Country Region Name to Axis section, and English Occupation to the Legend Section. This will automatically create a Clustered Column Chart for you.
Hover over any vertical bar will show you the Tool-tip of Country Name, Customer Occupation, and Sales Amount
Let me do some quick formatting to this Clustered Column Chart
NOTE: Formatting options for both Column Chart and Clustered Column Chart are same. So, I suggest you to refer Format Column Chart article to understand the steps involved in formatting the Clustered Columns.
Thank You for Visiting Our Blog