Skip to main content




The Power BI clustered bar chart is used to display horizontal bars from multiple data regions (measures) in a single metric. Let me show you how to create a clustered bar chart in Power BI with an example.

For this Power BI clustered bar chart demo, we used the SQL data source that we created in our previous article. So, check out the article Connect Power BI to SQL Server 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 below the Display section. Automatically creates a clustered bar chart with dummy data.

clustered-bar-chart-in-power-bi-1-2045371

To add data to the clustered bar chart, we have to add the required fields:

  • Axis: Specify the main column that represents the horizontal axis.
  • Legend: Specify the second column that represents the horizontal bars.
  • Values: Any numerical value such as sales amount, sales, orders, etc.

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

clustered-bar-chart-in-power-bi-2-4153335

Next, let me add the name of the country region in English to the Axis section to create a bar chart. This chart shows the sales amount by country region name in English.

clustered-bar-chart-in-power-bi-3-7494076

Then add Color from the DimProduct table to the Legend section.

clustered-bar-chart-in-power-bi-4-4580640

Create a Clustered Bar Chart Approach 2

To create a clustered bar chart in Power BI, first drag and drop the Sales Amount section of the fields to the region of the canvas. Automatically create a column chart.

clustered-bar-chart-in-power-bi-5-3656533

Next, let me add the name of the country region in English to the Axis section. Then click on the clustered bar chart below the Display section will convert column chart to clustered bar chart

clustered-bar-chart-in-power-bi-6-7194039

Let me add the Color section to the legend to create a clustered bar chart showing the sales amount by country name and color.

clustered-bar-chart-in-power-bi-7-8348820

Hover over any horizontal bar to display the tooltip for country name, product color, and its sales amount

clustered-bar-chart-in-power-bi-8-1822059

Let me apply a quick format to this clustered Power BI bar chart

NOTE: The formatting options for bar charts and clustered bar charts are the same. Therefore, I suggest that you refer to the article Formatting Bar Chart to understand the steps required to format clustered bars.

clustered-bar-chart-in-power-bi-9-1092471




The Power BI clustered bar chart is used to display horizontal bars from multiple data regions (measures) in a single metric. Let me show you how to create a clustered bar chart in Power BI with an example.

For this Power BI clustered bar chart demo, we used the SQL data source that we created in our previous article. So, check out the article Connect Power BI to SQL Server 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 below the Display section. Automatically creates a clustered bar chart with dummy data.

clustered-bar-chart-in-power-bi-1-2045371

To add data to the clustered bar chart, we have to add the required fields:

  • Axis: Specify the main column that represents the horizontal axis.
  • Legend: Specify the second column that represents the horizontal bars.
  • Values: Any numerical value such as sales amount, sales, orders, etc.

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

clustered-bar-chart-in-power-bi-2-4153335

Next, let me add the name of the country region in English to the Axis section to create a bar chart. This chart shows the sales amount by country region name in English.

clustered-bar-chart-in-power-bi-3-7494076

Then add Color from the DimProduct table to the Legend section.

clustered-bar-chart-in-power-bi-4-4580640

Create a Clustered Bar Chart Approach 2

To create a clustered bar chart in Power BI, first drag and drop the Sales Amount section of the fields to the region of the canvas. Automatically create a column chart.

clustered-bar-chart-in-power-bi-5-3656533

Next, let me add the name of the country region in English to the Axis section. Then click on the clustered bar chart below the Display section will convert column chart to clustered bar chart

clustered-bar-chart-in-power-bi-6-7194039

Let me add the Color section to the legend to create a clustered bar chart showing the sales amount by country name and color.

clustered-bar-chart-in-power-bi-7-8348820

Hover over any horizontal bar to display the tooltip for country name, product color, and its sales amount

clustered-bar-chart-in-power-bi-8-1533794

Let me apply a quick format to this clustered Power BI bar chart

NOTE: The formatting options for bar charts and clustered bar charts are the same. Therefore, I suggest that you refer to the article Formatting Bar Chart to understand the steps required to format clustered bars.

clustered-bar-chart-in-power-bi-9-2590508
R Marketing Digital