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 represent the vertical bars of multiple regions against a single Metric.
In a Clustered column chart, the Axis is represented on the X-axis, and Data is represented on Y-axis. Let’s have a look at the below clustered chart example:
In the above example, we can see that the chart visualizes the data on Sales(Values) by Product(Product) and country, which are 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 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.
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 text file, etc.
Open Power BI Desktop > Get Data > More… > All/File > Excel > Connect.
Then select the excel data from the local system and click on open.
After clicking on open, it will redirect to the navigator page. Now, on the navigator page navigate the Selected excel data > click on Load.
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 the field:
- Axis: Product
- Legend: Country
- Values: Profit
In 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.
There are 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:
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.
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:
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.
For this multi-value visualizations, we have taken these fields:
On clustered column chart, it does not allow Legends when using multiple values. Now the chart will look below:
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.
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:
Create a simple Clustered column chart having Axis and Values fields like below:
Go to Format Pane > Data color > click on Conditional formatting(fx).
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.
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 conditions on Center and Maximum. Then select OK.
Then the Clustered column chart will look like below after applying conditional formatting:
This is how we can do conditional formatting on Power BI Clustered column chart.
Power BI Clustered Column Chart percentage
Here we will see how to show percentage on a Clustered Column chart by following these steps:
Create a clustered column chard having Axis and Values field. For example, we will create a clustered column chart like below:
Select the drop-down of Profit(on values field) > show value as > Percent of total.
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 the total, the chart will look like this:
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 vary 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:
Create a clustered column chart. For example, we will create a clustered column chart that shows the data like below:
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 the 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 the financial datasheet.
Then the chart will look like below:
Under the Format pane, select the drop-down of the Y-axis. Then scroll down until we see the secondary axis. Because there are so many options on Y-axis, so we have to use both scrollbars.
For displaying the Secondary axis on the chart, Turn on the Show secondary option. Then the chart will look like below with having a secondary axis.
On the above chart, we can see the secondary axis in the right position. We can customize its position to right or left.
This is how to show Power BI Clustered Column Chart secondary axis.
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:
Create a clustered column chart. For example, we will create a chart which displays the profit and discounts of the Product.
As we use the Profits, Discounts, and Product on this chart, we can do a 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 orders on Discount:
Select the chart > More option(…) > Sort by > Discounts.
We can see on the above chart, Discount is sorted in 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 a discount, then it will be sort by ascending or descending order as alphabetically like this:
This is how to do sort order on Power BI Clustered Column Chart.
Power BI Clustered Column Chart space between bars
Here we will show how to adjust the spaces between bars on Clustered column chart:
Create a Clustered column chart. For example, here we create a Clustered column chart like below:
Go to Format Pane > X-axis > Inner Padding.
Decrease the percentage of Inner padding, it will adjust the spacing between the bars like this:
In this way, we can manage the space between bars.
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.
Here we prepare data like this:
Create a Clustered column chart using this data. Then the chart will look like this:
Let’s group the Legend i.e. Zone. For this right-click on Zone. Select New group.
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).
Click on OK. Then the chart will appear with grouping:
In 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:
- Power BI Funnel Chart
- Power bi best practices
- Microsoft Power BI Stacked Column Chart
- Power BI waterfall chart
- Power Bi Schedule Refresh
- Power BI combine columns from two tables
- Power BI Information Functions
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?
After working for more than 15 years in Microsoft technologies like SharePoint, Office 365, and Power Platform (Power Apps, Power Automate, and Power BI), I thought will share my SharePoint expertise knowledge with the world. Our audiences are from the United States, Canada, the United Kingdom, Australia, New Zealand, etc. For my expertise knowledge and SharePoint tutorials, Microsoft has been awarded a Microsoft SharePoint MVP (9 times). I have also worked in companies like HP, TCS, KPIT, etc.