Power BI Clustered Column Chart

In this Power BI Tutorial, we will learn what is Power BI Clustered Column Chart? Also, we will discuss:

  • Power BI Clustered Column Chart
  • How to create a Power BI Clustered Column Chart
  • Power BI Clustered Column Chart multiple values
  • Power BI Clustered Column Chart conditional formatting
  • Power BI Clustered Column Chart percentage
  • Power BI Clustered Column Chart secondary axis
  • Power BI Clustered Column Chart sort order
  • Power BI Clustered Column Chart space between bars
  • Power BI Clustered Column Chart grouping

Power BI Clustered Column Chart

On Power BI, the Clustered column chart is useful to display the comparison of multiple series as in the vertical axis. We can describe as a Clustered Column Chart is used to represents the vertical bars of multiple regions against a single Metric.

In a Clustered column chart, the Axis represented on the X-axis, and Data represented on Y-axis. Let’s have a look on the below clustered chart example:

Power BI Clustered Column Chart
Power BI Clustered Column Chart

On the above example, we can see that the chart visualize the data on Sales(Values) by Product(Product) and country, which differentiated into color bars.

Read: Power BI Export Data

Required fields or component to create a Clustered Column chart

Before creating a Clustered column chart, first we have to consider on these components:

  • Axis: It is specified as the main column, which displays the vertical axis.
  • Legend: It is specified as the second column, which displays the vertical bar differentiated into bar colors.
  • Values: It contains any numeric value, i.e, Amount, profit, units, etc.
  • Title: It describes the short information about the visual.

How to create a Power BI Clustered Column Chart

The clustered chart is very simple and easy to use. Let us create to understand how it works and how to create with an example. Here is the step-by-step guide to creating a clustered column chart using Excel data on Power BI.

Step-1:

For creating a Clustered column chart, we have to prepare data or we can download it from the browser. Here we are using sample excel data on basis of the Product’s finances report. Your data may be a SharePoint list, SQL database, Excel datasheet, or a text file, etc.

Step-2:

Open Power BI Desktop > Get Data > More… > All/File > Excel > Connect.

How to create a Power BI Clustered Column Chart
How to create a Power BI Clustered Column Chart

Step-3:

Then select the excel data from local system and click on open.

Step-4:

After clicking on open, it will redirect to the navigator page. Now, on the navigator page navigate the Selected excel data > click on Load.

Clustered column chart on power BI
Clustered column chart on power BI

Step-5:

On the Report Page, under visualizations select the clustered column chart. For example, we will create data that visualize the total Profit by Product and Country, and for this visualization drag these data from field:

  • Axis: Product
  • Legend: Country
  • Values: Profit
Clustered column chart on Power BI
Clustered column chart on Power BI

On the above example, we can see that Axis(Country) represented on X-axis, Values(Profit) represented on Y-Axis and Each Country differentiated into Legends(Product) with different colors.

Step-6:

There is another option Small multiples, which splits the visual into multiple parts of itself. Let’s have another example using Small multiples in that previous clustered column chart:

Power BI Clustered Column Chart
Power BI Clustered Column Chart using small multiples

We can see in the above visual, after applying the Month name on Small multiples the chart got split into multiple parts to itself. This is how to create a Clustered column chart on Power BI.

Read: How to change data source in Power BI

Power BI Clustered Column Chart multiple values

In Power BI Clustered Column chart, we can show multiple data by adding multiple values. Let’s take an example of a clustered column chart having multiple values:

Step-1:

On the Report page, add a Clustered column chart from visualizations. Now we will create a visual, that represents the whole data(Profit, sale, Gross sales, Discounts, etc.) of Products.

Step-2:

For this multi value visualizations, we have taken these fields:

Power BI Clustered Column Chart multiple values
Power BI Clustered Column Chart multiple values

On clustered column chart, it does not allow Legends when using multiple values. Now the chart will look below:

Power BI Clustered Column Chart multiple values
Power BI Clustered Column Chart multiple values

We can see each product on the X-axis represented with multiple values. This is how we can show multiple values on Power BI Clustered column chart.

Read: Power BI Donut Chart – How to use

Power BI Clustered Column Chart Conditional Formating

We can format Clustered column chart by applying conditions on that. By these following steps we can do conditional formatting on Clustered column chart:

Step-1:

Create a simple Clustered column chart having Axis and Values fields like below:

Power BI Clustered Column Chart conditional formatting
Power BI Clustered Column Chart conditional formatting

Step-2:

Go to Format Pane > Data color > click on Conditional formatting(fx).

Power BI Clustered Column Chart conditional formatting
Power BI Clustered Column Chart conditional formatting

Step-3:

Then it will redirect a, where we can apply conditional formatting the visual. There are 3 different types of formats as Color Scale, Rules, Fields values. Let’s do format by Color scale.

Conditional formatting on Clustered column chart
Conditional formatting on Clustered column chart

We can set the lowest value or Custom value with its respective color from the color chart in this format. Like Minimum, we can apply condition on Center and Maximum. Then select OK.

Then the Clustered column chart will look like below after applying conditional formatting:

Power BI Clustered Column Chart conditional formatting
Power BI Clustered Column Chart conditional formatting

This is how we can do conditional formatting on Power BI Clustered column chart.

Read: Power bi calculated column vs measure

Power BI Clustered Column Chart percentage

Here we will see how to show percentage on a Clustered Column chart by following these steps:

Step-1:

Create a clustered column chard having Axis and Values field. For example, we will create a clustered column chart like below:

Clustered Column Chart percentage
Clustered Column Chart percentage

Step-2:

Select the drop-down of Profit(on values field) > show value as > Percent of grand total.

Clustered Column Chart percentage
Clustered Column Chart percentage

Make sure to turn ON the data label on the Format pane otherwise, data will not show on the chart. After selecting the Percent of grand total, the chart will look like this:

Power BI Clustered Column Chart percentage
Power BI Clustered Column Chart percentage

This is how we can show the percentage on Clustered column chart easily.

Read: Power BI Column Chart

Power BI Clustered Column Chart Secondary Axis

A secondary axis can be used as a part of a combination chart when we have mixed types of data in the same chart.

When the values in a chart very widely from data series to data series, we can plot one or more data series on a secondary axis.

A secondary axis runs along the right side of the chart. Here, we will see how to show a secondary axis in a Clustered column chart with step by step guides:

Step-1:

Create a clustered column chart. For example, we will create a clustered column chart that show the data like below:

Power BI Clustered Column Chart secondary axis
Power BI Clustered Column Chart secondary axis

Step-2:

Convert this clustered column chart to a combo chart. There are 2 types of combo charts available: Line and stacked column chart, Line and clustered column chart. Now we will convert this chart to Line and clustered column chart.

For converting, first select the column chart, then under visualization pane select the Line and Clustered column chart.

We can see under the Fields pane, it will ask to add Line values. Here drag Gross Sales from financial datasheet.

Then the chart will look like below:

Power BI Clustered Column Chart secondary axis
Power BI Clustered Column Chart secondary axis

Step-3:

Under Format pane, select the drop-down of Y-axis. Then scroll down until we see the secondary axis. Because there are so many options in Y-axis, so we have to use both scrollbar.

Secondary axis on clustered column chart
Secondary axis on clustered column chart

Step-4:

For displaying the Secondary axis on chart, Turn on the Show secondary option. Then the chart will look like below with having secondary axis.

Power BI Clustered Column Chart secondary axis
Power BI Clustered Column Chart secondary axis

On the above chart, we can see the secondary axis on the right position. We can customize its position to right or left.

This is how to show Power BI Clustered Column Chart secondary axis.

Read: How to use Power BI Desktop

Power BI Clustered Column Chart sort order

We can sort our data directly on a clustered column chart. Let’s see the examples of Clustered column charts:

Step-1:

Create a clustered column chart. For example, we will create a chart which displaying the profit and discounts of the Product.

Clustered Column Chart sort order
Clustered Column Chart sort order

Step-2:

As we use the Profits, Discounts and Product on this chart, we can do sort on those three data. We can see the chart is by default showing the profit, sorted by descending. Now we will see how to sort order on Discount:

Select the chart > More option(…) > Sort by > Discounts.

Power BI Clustered Column Chart sort order
Power BI Clustered Column Chart sort order

We can see on the above chart, Discount is sorted as descending order. There is a Yellow trigger(left side on the Discount and sort descending), that indicating our selected options.

If we sort the product as discount, then it will be sort by ascending or descending order as alphabetically like this:

Power BI Clustered Column Chart sort order
Power BI Clustered Column Chart sort order

This is how to do sort order on Power BI Clustered Column Chart.

Read: Power bi row level security tutorial

Power BI Clustered Column Chart space between bars

Here we will show how to adjust the spaces between bars on Clustered column chart:

Step-1:

Create a Clustered column chart. For example, here we create a Clustered column chart like below:

Clustered column chart on Power BI
Clustered column chart on Power BI

Step-2:

Go to Format Pane > X-axis > Inner Padding.

Clustered column chart on Power BI spacing
Clustered column chart on Power BI spacing

Step-3:

Decrease the percentage of Inner padding, it will adjust the spacing between the bars like this:

Power BI Clustered Column Chart space between bars
Power BI Clustered Column Chart space between bars

In this way, we can manage the space between bars.

Read Power bi treemap – How to use

Power BI Clustered Column Chart Grouping

In Power BI, we can group data to help us more clearly view, analyze, and explore data in our visual. Let’s see how to grouping data on Power BI Clustered column chart.

Step-1:

Here we prepare data like this:

Power BI Clustered Column Chart grouping
Power BI Clustered Column Chart grouping

Step-2:

Create a Clustered column chart using this data. Then the chart will look like this:

Power BI Clustered Column Chart grouping
Power BI Clustered Column Chart grouping

Step-3:

Let’s group the Legend i.e. Zone. For this right click on Zone. Select New group.

Power BI Clustered Column Chart grouping
Power BI Clustered Column Chart grouping

Step-4:

It will redirect to the grouping page. Here we will create groups on the Zone. Ex: we will create an East, West, and other groups (mix of rest ungrouped, i.e. North and South).

Power BI Clustered Column Chart grouping
Power BI Clustered Column Chart grouping

Step-5

Click on OK. Then the chart will appear with grouping:

Clustered Column Chart grouping
Clustered Column Chart grouping

On the above example, we can see that chart is grouped by East, West and Other.

This is how we can grouping on Power BI Clustered column chart.

You may like the following Power BI tutorials:

Conclusion

From this above tutorial, we learned all about Power BI Clustered column chart. Also, we discussed:

  • What is Power BI Clustered Column Chart?
  • How to create a Power BI Clustered Column Chart?
  • What are multiple values on Power BI Clustered Column Chart?
  • How to do conditional formatting on Power BI Clustered Column Chart?
  • How to show the percentage on Clustered Column Chart?
  • How to show the secondary axis on Clustered Column Chart?
  • How to do sorting on Clustered column chart?
  • How to show grouping on Clustered column chart?
>