Power BI Clustered Bar Chart + 7 Useful Examples

Do you want to learn about the Power BI Clustered bar chart? In this Power BI tutorial, we will see what a clustered bar chart in Power BI is and its uses.

Moreover, we will cover the following topics:

  • How to create a clustered bar chart in Power BI
  • Clustered bar chart power bi change order
  • Power BI clustered bar chart increases bar width
  • Power BI clustered bar chart overlap
  • Power BI clustered bar chart space between bars
  • Clustered bar chart power bi multiple values
  • Clustered bar chart Power BI percentage
  • Conditional formatting clustered bar chart Power BI

Power BI Clustered Bar Chart

A clustered bar chart in Power BI is a type of horizontal chart where multiple bars are grouped together horizontally under the same y-axis values, forming clusters.

Clustered bar chart power bi change order

How to create a clustered bar chart in Power BI

Here we will see how to create a clustered bar chart in Power BI.

For example, we will use the Sales.xlsx table to create a clustered bar chart in Power BI.

clustered bar chart power bi

Using the data, we will show sales and profit based on Product Category in a Clustered bar chart.

Follow the below steps to create a clustered bar chart in Power BI.

  • Login to Power BI Desktop and load the data from the data source using the Get Data option.
  • Then select the Clustered bar chart from the Visualization pane, and you can see the blank visual created in Canvas.
clustered bar chart
  • Next, drag and drop the Product Category to the Y-axis and the Sales and Profit to the X-axis.
  • You can see a cluster bar chart displaying sales and Profits based on product category.
power bi clustered bar chart

This is how we can create a cluster bar chart in Power BI.

Clustered bar chart Power BI change order

Here, we will see how to change the order in the Power BI Clustered bar chart.

For example, we will take the above Power BI clustered bar chart and sort the X-axis in ascending order.

  • To do this, select the clustered bar chart in Power BI Canvas and click on More options (…).
  • Then select Sort axis -> Product Category -> Sort ascending option.
power bi clustered bar chart sort order

Now, you can see the clustered bar chart, X-axis, i.e., the Product Category is sorted in Ascending order.

Clustered bar chart power bi change order

This is how we can change the order of the Power BI Cluster bar chart.

See also  Power BI DAX Logical functions [7 Examples]

Power BI clustered bar chart increases bar width

To increase the bar width in the Power BI clustered bar, refer to the example below.

For example, to increase the bar width in the above Cluster bar chart in Power BI. Follow the below steps.

  • To do this, select the Cluster bar chart, click the Format pane, and expand the bar section. Select the series as ‘ALL’.
  • Then, expand the Layout section here and increase the slider under Space between the categories.
  • You see the bar width get an increase in the Power BI Clustered bar chart.
power bi clustered bar chart increase bar width

This is how we can Power BI clustered bar chart to increase bar width.

Power BI clustered bar chart overlap

Here, we will see how to create an overlapping cluster bar chart in Power BI.

For example, to overlap the bars on top of each other in the above Power BI Cluster bar chart.

  • To do this, select the Cluster bar chart, click the Format pane, and expand the bar section. Select the series as ‘ALL’.
  • Then, expand the Layout section here and toggle on the Overlap option.
  • Next, slide the ‘Space between series’ slider. You can see the bars overlap with each other
power bi clustered bar chart overlap

If you want to flip the overlap, the blue color will be on top of the navy blue. In that case, you need to turn on the Flip overlap option. You can see something like this below.

power bi overlapping bar chart

This is how we can create an overlapping cluster bar chart in Power BI.

Power BI clustered bar chart space between bars

Here, we will see how to add space between bars in the Power BI Clustered bar chart.

For example, in Power BI, we will add space between the series of bars in the above Cluster bar chart.

  • To do this, select the Cluster bar chart, click the Format pane, and expand the bar section. Select the series as ‘ALL’.
  • Then, expand the Layout section here and increase the slider under Space between the categories.
  • To add space between the bars in each category in the Clustered bar chart in Power BI, increase the slider under ‘Space between series.’
  • You can see the space between the clustered bar in Power BI.
increase space between bars in power bi

This is how we can increase space between bars in the Cluster bar chart in Power BI

See also  How to create Power BI report from SharePoint list + Excel

Clustered bar chart Power BI multiple values

Here we will see how to create a cluster bar chart with multiple values in Power BI.

For example, we will use the same Sales.xlsx table to show sales, profit, and COGS based on the Product name in a Clustered bar chart.

clustered bar chart power bi

Follow the below steps to create a clustered bar chart to show multiple values.

  • Select the Clustered bar chart from the visualization pane in Power BI Desktop.
clustered bar chart
  • Then, drag and drop the Product name to the X-axis and Sales, Profit, and COGS to the Y-axis of the cluster bar chart.
  • Now you can see we have added multiple values, such as Sales, Profit, and COGS, to the Cluster bar chart.
  • You can see the cluster bar chart shows sales, profit, and COGS by product name.
Power bi bar chart with multiple values

This is how we can create a Power BI Clustered bar chart with multiple values.

Clustered bar chart Power BI percentage

Here, we will see how to show the percentages in the Power BI Clustered bar chart.

For example, we will use the same Sales.xlsx table to show sales and profit based on the Product Category in a Clustered bar chart.

clustered bar chart power bi

Follow the below steps to create a clustered bar chart to show multiple values.

  • Select the Clustered bar chart from the visualization pane in Power BI Desktop.
clustered bar chart
  • Next, drag and drop the Product Category to the Y-axis and the Sales and Profit to the X-axis.
  • You can see a cluster bar chart displaying sales and Profits based on product category.
what is a clustered bar chart

Then select the drop-down next to the ‘Sum of sales,’ and select ‘Show value as. -> Percentage of Grand total.

clustered bar chart power bi percentage

Similarly, I have selected Percent of the grand total for Profit. Then, you can see the percent in the Power BI Cluster bar chart.

clustered bar chart in power bi percentage

This is an example of show percentage in Clustered bar chart in Power BI .

Conditional formatting clustered bar chart Power BI

Here, we will see how to format the cluster bar chart in Power BI conditionally.

For example, we will use the below Sales Excel table to create a Clustered bar chart.

The Clustered bar chart will display the Sales based on Product Name.

clustered bar chart power bi

We will change the color gradient of the bars in the Clustered bar chart based on the sales value.

Three parameters—the lowest value, the middle value, and the highest value—define the gradient.

Suppose the lowest sales amount is 400, and the maximum amount is 1000. In that case, the bar color will transition from yellow for lower sales to pink for higher sales, with shades in between reflecting varying sales amounts.

See also  Power Automate Array Variable + 15 Examples

Follow the steps below to apply conditional formatting on the Power BI Cluster bar chart based on color.

  • In Power BI Desktop, load the data using the Get Data option.
  • Then, select the cluster bar chart from the visualization pane; it gets created in Power BI Canvas.
conditional formatting clustered bar chart power bi
  • To show the sales based on Product name, drag and drop the Sales and product name columns to the X and Y axis, respectively, in the field pane.
conditional formatting clustered bar chart in power bi
  • Next, click the Format icon in the Visualization pane, then expand the Bars section.
  • Click on the fx in the color section.
 Power BI clustered bar chart conditional formatting
  • The Conditional Formatting window will open. Provide the following information:
  • Select the Format style as a Gradient.
  • Choose the Sales field in ‘What field should we base this on, ‘and select Sum as Summarization.
  • Next, ‘How should we format empty values‘ as ‘As zero‘.
  • Then, in Minimum value, select Custom from the dropdown and enter the value as 400. Select the color.
  • For the Maximum value, select Custom from the dropdown and enter 1000. Then, select the color.
  • Also, you can enable the middle value by checking the box to add a middle color. Then click on OK.
conditional formatting clustered bar chart

Now, you can see the clustered bar chart with conditionally formatted in Power BI.

conditional formatting Power BI clustered bar chart

This is an example of conditional formatting clustered bar chart in Power BI.

Also, you may like:

Conclusion

In this Power BI tutorial, we saw what is a Clustered bar chart in Power BI, and how to create a Power BI clustered bar chart. Also, we cover the topics below:

  • How to create a clustered bar chart in Power BI
  • Clustered bar chart power bi change order
  • Power BI clustered bar chart increases bar width
  • Power BI clustered bar chart overlap
  • Power BI clustered bar chart space between bars
  • Clustered bar chart power bi multiple values
  • Clustered bar chart Power BI percentage
  • Conditional formatting clustered bar chart Power BI
>