Clustered Column Chart in Power BI

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:

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.