Clustered Bar Chart in Power BI

Power BI Clustered Bar Chart is used to display horizontal bars of multiple data regions (Measures) against a single Metric. Let me show you how to Create Clustered Bar Chart in Power BI with example.

For this Power BI Clustered Bar Chart demonstration, we use the SQL Data Source that we created in our previous article. So, Please refer to Connect Power BI to SQL Server article to understand the Data Source in Power BI.

How to Create a Clustered Bar Chart in Power BI

First, click on the Clustered Bar Chart under the Visualization section. It automatically creates a Clustered Bar Chart with dummy data.

Clustered Bar Chart in Power BI 1

To add data to the Clustered Bar Chart, we have to add the required fields:

  • Axis: Please specify the Main Column that represents the Horizontal Axis.
  • Legend: Specify the second Column that represents Horizontal Bars.
  • Values: Any Numeric value such as sales amount, Sales, Orders, etc.

Let me drag the Sales Amount from Fields section to Values field

Clustered Bar Chart in Power BI 2

Next, let me add the English Country Region Name to Axis section to create a Bar chart. This Chart shows the Sales Amount by English Country Region Name.

Clustered Bar Chart in Power BI 3

Next, add Color from DimProduct table to the Legend section.

Clustered Bar Chart in Power BI 4

Create a Clustered Bar Chart Approach 2

To create a Clustered Bar Chart in Power BI, first Drag and Drop the Sales Amount from Fields section to Canvas region. It automatically creates a Column Chart.

Clustered Bar Chart in Power BI 5

Next, let me add the English Country Region Name to the Axis section. Next, click on the Clustered Bar Chart under the Visualization section will convert the Column Chart into Clustered Bar Chart

Clustered Bar Chart in Power BI 6

Let me add Color to Legend section to create a Clustered Bar chart that shows Sales Amount by Country Name and Color.

Clustered Bar Chart in Power BI 7

Hover over any horizontal bar shows the Tool-tip of Country Name, Product Color, and its Sales Amount

Clustered Bar Chart in Power BI 8

Let me do some quick formatting to this Power BI Clustered Bar Chart

NOTE: Formatting options for both Bar charts and Clustered Bar charts are the same. So, I suggest you refer to the Format Bar Chart article to understand the steps involved in formatting the Clustered Bars.

Clustered Bar Chart in Power BI 9