Clustered Column Chart in Power BI + 6 Examples

Do you want to create a clustered column chart in Power BI? In this Power BI tutorial, we will learn what a clustered column chart is.

Also, we will cover the below topics:

  • How to create a clustered column chart in Power BI
  • Power BI clustered column chart spacing
  • Power BI clustered column chart sort x-axis
  • Power BI clustered column chart multiple values
  • Power BI clustered column chart secondary axis
  • power BI clustered column chart conditional formatting

What is Clustered Column Chart in Power BI

Power BI Clustered column chart is useful for displaying comparisons of multiple series along the vertical axis. It typically represents vertical bars for multiple regions in relation to a single metric.

Example: A Power BI clustered column chart is useful for comparing sales performance across different product categories over time. It allows users to identify trends and make data-driven decisions regarding inventory, promotions, and sales strategies.

How to create a clustered column chart in Power BI

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

To create a clustered column chart in Power BI, we will use the Sales.xlsx data.

on the vertical axis of the clustered column chart

Using the data, we will show Sales, profit, and Cogs based on Product Category in a Clustered column chart.

Follow the below steps to create a clustered column 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 column chart from the Visualization pane, and you can see the blank visual created in Canvas.
clustered column chart in power bi
  • Then, drag and drop the Product Category to the X-axis and Sales, Profit, and COGS to the Y-axis.
  • Now you can see the Clustered column chart showing sales, profit, and cogs based on the product category.
what is clustered column chart in power bi

This is how we can create a clustered column chart in Power BI.

Power BI clustered column chart spacing

Here, we will see how to add space between clustered columns in Power BI.

See also  Power Automate Rename File | Power Automate Rename SharePoint File

For example, we will add space between the series of columns in the above-clustered column chart in Power BI.

  • To do this, select the Cluster column chart, click the Format pane, and expand the column section.
  • Then, expand the Layout section here and increase the slider under Space between the categories.
  • You can see that the space between the categories in the Clustered column chart is increased.
power bi clustered column chart spacing
  • To add space between the columns in each category in the Clustered column chart in Power BI, increase the slider under ‘Space between series.’
  • You can see the space between the clustered columns in Power BI.
space between clustered columns power bi

This is how we can add space between clustered columns in power bi

Power BI clustered column chart sort x-axis

Here, we will see how to sort the X-axis in the Power BI Clustered column chart.

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

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

Now, you can see the clustered column chart, X-axis is sorted in Ascending order.

power bi clustered column chart sort order

This is how we can sort the X-axis in the Power BI clustered column chart

Power BI clustered column chart multiple values

Here, we will see how to show multiple values in the Power BI Clustered column chart.

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

clustered column

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

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

This is an example of a Power BI clustered column chart with multiple values.

See also  How to Remove Special Characters from a String in Power Automate?

Power BI clustered column chart secondary axis

Here, we will see how to add a secondary axis to the Power BI Clustered column chart.

Unfortunately, we cannot add the secondary axis to the Power BI Clustered column chart.

To overcome this issue, we will use a Combo chart, i.e., Line and Clustered column chart.

For this example, we will use the same Sales.xlsx table and show Sales and profit based on Products.

clustered column

Follow the below steps to create a Power BI clustered column chart with a secondary axis.

  • In Power BI Desktop, select the Line and Clustered column chart from the visualization pane.
  • Then drag and drop the Product name to the X-axis, Sales and profit to the Y-axis, and Profit to the Line y-axis.
power bi clustered column chart secondary axis
  • To hide the line and enable the Secondary y-axis. For this, click on the Format pane in the visualization pane.
  • Expand the Secondary y-axis section and enable the Values section.
power bi clustered column chart multiple y axis

Next, expand the Line section and make the width option 0.

clustered column chart

Then expand the Y-axis and further expand the Title; under ‘Title text,’ write Sum of Sales.’

power bi clustered column chart multiple y-axis

Now you can see the Power bi-clustered column chart having multiple y-axes.

power bi clustered column chart secondary y axis

This is an example of a Power BI clustered column chart secondary y-axis.

Power BI clustered column chart conditional formatting

Here, we will see how to apply conditional formatting to the Clustered column chart in Power BI.

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

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

clustered column

We will change the color gradient of the columns in the Clustered column 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 column color will transition from yellow for lower sales to pink for higher sales, with shades in between reflecting varying sales amounts.

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

  • In Power BI Desktop, load the data using the Get Data option.
  • Then, select the cluster column chart from the visualization pane; it gets created in Power BI Canvas.
See also  Power Automate IF with Examples
clustered column 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.
power bi clustered column chart different colors
  • Next, click the Format icon in the Visualization pane, then expand the Columns section.
  • Click on the fx in the color section.
change color of clustered column chart power bi
  • 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 of Add a middle color. Then click on OK.
clustered column chart different colors power bi

Now, you can see the clustered column chart with different colors in Power BI.

power bi clustered column chart conditional formatting

This is an example of a Power BI clustered column chart with different colors.

Some more Power BI articles you may like:

Conclusion

In this Power BI tutorial, we saw what the Power BI clustered column chart is. Furthermore, we have covered the topics below:

  • How to create a clustered column chart in Power BI
  • Power BI clustered column chart spacing
  • Power BI clustered column chart sort x-axis
  • Power BI clustered column chart multiple values
  • Power BI clustered column chart secondary axis
  • Power BI clustered column chart conditional formatting
>