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:
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.
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.
Open Power BI Desktop > Get Data > More… > All/File > Excel > Connect.
Then select the excel data from 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 field:
- Axis: Product
- Legend: Country
- Values: Profit
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.
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:
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 condition 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 grand 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 grand 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 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:
Create a clustered column chart. For example, we will create a clustered column chart that show 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 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:
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.
For displaying the Secondary axis on chart, Turn on the Show secondary option. Then the chart will look like below with having 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.
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 displaying the profit and discounts of the Product.
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.
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:
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:
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:
- 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
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?
I am Bijay from Odisha, India. Currently working in my own venture TSInfo Technologies in Bangalore, India. I am Microsoft Office Servers and Services (SharePoint) MVP (5 times). I works in SharePoint 2016/2013/2010, SharePoint Online Office 365 etc. Check out My MVP Profile.. I also run popular SharePoint web site SPGuides.com