In this Power BI Tutorial, we will discuss What is a clustered column chart in Power BI and how to create clustered column chart in Microsoft Power BI with a few examples, we will also learn about the conditional formatting in clustered column charts, and how we can add an average line and trend line in the clustered column chart Power BI with examples. And also covered the below-mentioned topics:
- What is clustered column chart in Power BI?
- How to create a clustered column Chart in Power BI
- Power BI clustered column chart multiple X-axis
- Power BI clustered column secondary axis
- Power BI clustered column chart remove a secondary axis
- Multiple values on a clustered column chart in Power BI
- Power BI clustered column chart sort order
- Power BI clustered column chart sorted by year
- Power BI clustered column chart sorted by month
- Power BI clustered column chart sorted by legend
- Power BI clustered column chart color based on the value
- Power BI clustered column chart space between bars
- Power BI clustered column chart add the line
- Power BI clustered column chart average line
- Power BI clustered column chart trend line
- Power BI clustered column chart month and year
- Power BI clustered column chart drill-down
- Power BI clustered column chart gridlines
- Power BI clustered column chart data labels
- Power BI clustered column chart legend
- Power BI clustered column chart multiple legends
- Power BI clustered column chart tooltip
- Power BI clustered column chart different filters
- Power BI clustered column chart x-axis label
- Power BI clustered column chart column width
- Power BI clustered column chart two y-axis
- Power BI clustered column chart y-axis title
- Power BI clustered column chart formatting
- Power BI clustered column chart count
- Power BI clustered column chart two tables
- Power BI clustered column chart with line
- Power BI clustered column chart date
- Power BI clustered column chart data colors
- Power BI clustered column charts of different colors
- Power BI clustered column chart show zero values
- Power BI clustered column chart drill-through
- Power BI clustered column chart value and percentage
- Power BI clustered column chart show only selected data
- Power BI clustered column chart padding
- Power BI clustered column chart white space
- Power BI clustered column chart vertical
- Power BI clustered column chart increases bar width
- Power BI clustered column chart reduces bar width
- Power BI clustered column chart by value
- Power BI clustered column chart can’t add legend
- Power BI clustered column chart grouping
- Power BI clustered column chart hides zero values
What is Clustered Column Chart in Power BI?
- Power BI Clustered column chart displays data with more than a single series in clustered vertical bars.
- By category, vertical bars are grouped based on the data series and share the same x-axis labels.
- In clustered column chart the data will be represented on the Y-axis and the axis represents the X-axis value.
Read How to create a report in Power BI Desktop?
How to create a clustered column chart in Power BI
Let us see how to create a clustered column chart in Power BI,
- Initially, Open the Power BI Desktop. Under the Home section, Expand the Get data option presented in the toolbar to connect the Data Source, and then click on the Excel workbook under the Common data sources option.
- Here, I have selected the Excel Workbook as my data source, we can also connect the data source from SQL Server, SharePoint List, etc.,
- Now browse the location of the excel workbook available in the local system, select the Excel workbook, and click on the open button as shown below:
- In the Navigator, select the excel sheet that you want to load and preview the data, and once you are satisfied that you are loading the right file, click on the Load option.
- It will take a few minutes to load the data into the Power BI desktop, Once the data is loaded you can confirm the data under the field section and the fields pane contains the column data presented in the excel workbook.
- Now under the Visualizations pane, select the Clustered column Chart option, you can see that the clustered column chart is added to the report canvas.
- In this example, we will see the clustered column chart displays the sales that occurred based on the product and country.
- For that in the X-axis field drag and drop the Product field. And in the Y-axis field drag and drop the sales field, and in the legend section drag and drop the Country field.
- In the below screenshot, you can see that the clustered column chart displays the value based on the sales that occurred based on the product and country in the report canvas.
This is how we can create a clustered column chart visual in Power BI.
Power BI clustered column chart multiple X-axis
Let us see how we can display data in the clustered column chart with Multiple x-axes,
- Directly, if we add two fields to the x-axis by default, it will take the first field data and display the column chart.
- The alternative that we can display the clustered column chart with multiple x-axes is using the drill-down feature.
To achieve this follow the below-mentioned steps:
- Load the data into the Power BI desktop, Once the data is loaded you can confirm the data under the Fields section and the fields pane contains the column data presented in the source data.
- Now under the Visualizations pane, select the Clustered column Chart option, you can see that the clustered column chart has been added to the report canvas.
- In this example, we use the clustered column chart to see the sales that occurred based on the country and product with multiple x-axes.
- X-axis – Country, Product
- Y-axis – Sales
- Now, select the drill-down feature to display clustered column chart data with the multiple x-axes as shown below:
This is how to display data in the clustered column chart with Multiple x-axes.
Read Power Query Date
Power BI clustered column secondary axis
Let us see how we can enable and display the secondary axis in Power BI clustered column,
- We use the Secondary axis when we have mixed-type data to be displayed in the same clustered column chart.
- When we enable the secondary axis option, we can see it appears on the right side of the clustered column chart.
To enable the Secondary axis option in the clustered column chart, follow the below steps:
- Create a clustered column and add the field data into it as shown below:
- Directly we cannot enable the clustered column chart secondary axis, to convert the clustered column chart to a combo chart.
- There are 2 types of combo charts in general: Line and clustered column chart and Line and stacked column chart. Here I have converted the clustered column chart to the Line and clustered column chart.
- Under visualization, the pane selects the Line and Clustered column chart. In the line y-axis field, just drag and drop the COGS field as mentioned below:
- Under the Format visual pane, Enable the secondary y-axis as shown below: In the right position of the line and clustered column chart, you can see the secondary axis is displayed.
This is how we can enable and display the secondary axis in Power BI clustered column.
Read Power Query Examples
Power BI clustered column chart remove a secondary axis
Let us see how to remove a secondary axis from the clustered column chart in Power BI,
To remove the secondary axis from the clustered column chart follow the below steps:
- Select the Line and Clustered column chart, under the Format visual pane, Disable the secondary y-axis as shown below:
- In the below screenshot of the line and clustered column chart, you can see the secondary axis in the right position is removed.
This is how to remove a secondary axis from the clustered column chart in Power BI.
Read Create table using Power Query in Power BI
Multiple values on a clustered column chart in Power BI
Let us how we can display Multiple values on a clustered column chart in Power BI,
In this example, we use a clustered column chart to see the Profit, Sales, COGS, and Gross values that occurred based on the Product.
- Make sure the source data has been loaded into the Power BI desktop. Now under the Visualizations pane, select the Clustered column Chart option, you can see that the column chart is added to the report canvas.
- Now simply drag and drop the column fields under the Y-axis section in the visualizations pane to add multiple values.
- For that in the X-axis field drag and drop the Product field, and in the Y-axis field drag and drop the Profit, Sales, COGS, and Gross values fields as highlighted below:
This is how to display Multiple values on a clustered column chart in Power BI.
Read Power BI integration with PowerApps Portals
Power BI clustered column chart sort order
Let us see how we can sort the clustered column chart in Power BI,
- Select the Clustered column chart that you want to sort, In this example, the clustered column chart displays the Sales and Profit of the Product as shown below:
- Select the clustered column chart and click on the ellipsis in the upper right.
- Now select the Sort axis and choose the X-axis data field which is the Product field. And also you can see we can sort the X-axis either in the Sort ascending manner or Sort descending manner.
- The below-represented screenshot sorted the x-axis field data in the ascending form (ie, A to Z form).
- The below-represented screenshot, sorted the x-axis field data in the descending form (ie, Z to A form).
This is how we can sort the clustered column chart in Power BI.
Read Power BI if date
Power BI clustered column chart sorted by year
Let us see how we can sort clustered column charts based on the year in Power BI,
- Select the Clustered column chart that you want to sort based on the year, In this example, the clustered column chart displays the Sales and Profit of the year as shown below:
- Now under the visualizations, Expand the X-axis in the visual settings, and change the type from Continuos to Categorical as mentioned below:
- Select the clustered column chart and select the ellipsis in the upper right corner.
- Now choose the Sort axis and choose the X-axis data field which is the Year field. And also you can see we can sort the X-axis either in the Sort ascending manner or Sort descending manner.
- The below screenshot represents sorted the x-axis Year field data in the ascending form (ie, A to Z form).
- The below screenshot represents sorted the x-axis Year field data in the descending form (ie, Z to A form).
This is how we can sort clustered column charts based on the year in Power BI.
Read Power BI IF
Power BI clustered column chart sorted by month
Let us see how we can sort the clustered column chart based on the Month in Power BI,
Yes, sorting the clustered column chart based on the Month in ascending and descending order is possible.
Follow the below steps to sort the column chart based on the Month:
- Select the Clustered column chart that you want to sort based on the Month, In this example, the clustered column chart displays the Sales by month as shown below:
- Select the clustered column chart and select the ellipsis in the upper right corner.
- Now choose the Sort axis and choose the X-axis data field which is the Month field. And also you can see we can sort the X-axis either in the Sort ascending manner or Sort descending manner.
- The below screenshot represents sorted the x-axis Month field data in the ascending form (ie, A to Z form).
- The below screenshot represents sorted the x-axis Month field data in the descending form (ie, Z to A form).
This is how to sort clustered column charts based on the Month in Power BI.
Read Power BI Pie Chart
Power BI clustered column chart sorted by legend
Let us see how we can sort the clustered column chart based on the legend section in Power BI,
Before that, we should know that we can only add one legend into the legend section, Multiple legends are not allowed in the legend section.
- Select the Clustered column chart that you want to sort based on the Month, In this example, the clustered column chart displays the Sales by month and country as shown below:
- In the legend section, simply drag and drop the country field.
- Select the clustered column chart and select the ellipsis in the upper right corner.
- Now choose the Sort Legend and choose the legend data field which is the Country field.
- The below screenshot represents sorted the legend field data in the ascending form (ie, A to Z form).
- The below screenshot represents sorted the legend field data in the descending form (ie, Z to A form).
This is how we can sort the clustered column chart based on the legend section in Power BI.
Read Power BI Switch – DAX function
Power BI clustered column chart color based on the value
Let us see how to change the column color chart based on the value in Power BI,
Either we can apply the custom values to change the color, or we can choose the default values[lowest value, middle value, highest value]
Follow the below steps to change the clustered column chart:
- Now under the Visualizations pane, select the Clustered column Chart option, you can see that the clustered column chart has been added to the report canvas.
- In this example, we use the clustered column chart to see the sales that occurred based on the country and product with multiple x-axes.
- X-axis – Country, Product
- Y-axis – Sales
- Select Format Visual under the Visualisation pane, Expand the Columns under the Visual tab (highlighted in Red), and click on the Fx icon as shown below:
- Now, Select the Format style as Gradient and choose the column field value, Either we can add a custom value in the Enter a value field or We can leave the values by default, lowest value, Middle value, and Highest Value.
- Click on the Ok button to apply the conditional formatting for the clustered column chart.
- In the below screenshot, we can see that the Column chart has been formatted based on the Values.
This is how to change the column color chart based on the value in Power BI.
Read Power BI Card
Power BI clustered column chart space between bars
Let us see how to adjust the clustered column chart Space between bars in Power BI,
- Select the clustered column chart for which you want to adjust the space between bars. We can adjust the column bar size by increasing or decreasing the inner padding percentage.
- In this example, I have created a clustered column chart as shown below:
- Select Format Visual under the Visualisation pane, Expand the Columns under the Visual tab (highlighted in Red), and expand the Spacing option -> inner padding:
- We also have the chance to reset to the default values by selecting the reset to default option.
- The below screenshot represents the clustered column bar chart with space in Power BI.
- When we decrease the percentage of Inner padding, you can see that there is no space in between bars as shown below:
This is how we can adjust the space between the bars in the clustered column chart in the Power BI.
Read Power BI Measure Sum and Subtract Example
Power BI clustered column chart reference line
Let us see how to add the reference line on the Power BI desktop,
- By using, the clustered column chart analytics pane we can add the reference line to the visuals. The Analytics pane only occurs when you select a visual on the Power BI Desktop canvas.
- Under the visualizations, we can find the analytics icon on the Power BI desktop. Select the clustered column chart that you have created, In the right-hand side you can see the visualizations, you can find the analytics icon under the visualizations.
- In this example, I am going to show the Percentile line. We can add one or more reference lines in the clustered column chart visual.
- Expand the Percentile line, and select the +Add line under the application settings option. Once the line is added, Under the series, select the series for which you want to add a reference line. Here I have selected the Sales column field.
- Under the Line Option, we can change the color of the line, Transparency, and also the line style that we want to display for the reference line in the Power BI column chart.
- If we want to enable a data label, by default the data label will be turned off. If we want to know the data then we have to enable it. We can also change the color, position, and style of the data value.
This is how to add the reference line on the Power BI desktop.
Read Remove blank from Power bi slicer
Power BI clustered column chart average line
Let us see how we can add the average line to the clustered column chart in Power BI,
Here, In this example, we use the Sales value to calculate the average line on the clustered column chart.
- Select the clustered column bar chart that you have created, On the right-hand side we can see the visualizations, we can find the analytics icon under the visualizations.
- Here we will see an example of the average line in a clustered column chart.
- Expand the Average line, and select + Add line under the application settings to option. Once the line is added, Under the series, select the series for which you want to add a reference line. Here I have specified the Sales column field.
- We can also change the line style and enable the data label option which is available for the reference line.
This is how we can add the average line to the clustered column chart in the Power BI.
Read Difference between USERNAME() and USERPRINCIPALNAME() in Power BI Dax
Power BI clustered column chart trend line
Let us see how to create and add a trend line in the clustered column chart Power BI,
- Yes, the Trend line option supports the clustered column chart visual.
- In this example, we use a Trend Line to see the sales that occurred based on the year and country, for that in the X-axis field drag and drop the Date field. And in the Y-axis field drag and drop the sales field and in the legend section drag and drop the Country field.
- Make sure the x-axis field data is a type continuous, because The trend line feature only works with continuous data, so Under Format Visual, so make sure the Selected Chart type displays the type Continuous as shown below:
- Now we have to enable the Trend line toggle control in the analytics pane, under the visualizations.
- We also have an option to change the color of the trend line using line style and transparency. We can also reset the default values, by selecting the rest to the default option.
This is how to create and add a trend line in the clustered column chart Power BI.
Read What is the difference between calculated column and measure in Power BI
Power BI clustered column chart month and year
Let us see how can we show data by month and year in the clustered column chart visual Power BI,
In this example, we use a line Clustered column Chart to see the sales that occurred based on the Month and year, for that in the X-axis field drag and drop the Month field and Year field. And in the Y-axis field drag and drop the Sales field.
- Make sure that the source data has been loaded to the Power BI desktop.
- Now under the Visualizations pane, select the Clustered column Chart option, you can see that the column Chart is added to the report canvas.
- Then click on the drill down icon, to show the sales by year and month data in the Clustered column Chart.
- In the below screenshot, you can see that the Clustered column Chart displays the Sales that occurred based on the Month and year in the report canvas.
This is how can we show data by month and year in the clustered column chart visual Power BI.
Read Power bi free vs pro vs premium
Power BI clustered column chart drill-down
Now we will discuss how we can work with clustered column chart drill-down feature in Power BI.
- Drill requires a hierarchy, when there is no hierarchy in the clustered column chart visual then we cannot see the drill icons.
- There are two ways that we can access the drill features, Either we can directly hover over the clustered column chart visual or we can right-click the clustered column chart visual and select show next level or drill-up.
- Prefer the Up arrow to drill up to the earlier level of the clustered column chart hierarchy and the double down arrow to the following level of the clustered column chart hierarchy.
Follow the below-mentioned steps to show drill-up and drill-down features:
- Select the clustered column chart and add it to the Power BI report canvas, In this example, we will use the column chart to see the Sales that happened based on the product and country with the hierarchy.
- For that, In the x-axis field drag and drop the Product column field and in the Y-axis drag and drop the Sales column field as shown below:
- In the below screenshot, you can see that there is no drill down or drill up features because there is no hierarchy.
- For example, if we add one more column field into the x-axis field then we can able to see the drill-down features.
- When we click on the drill down icon ( highlighted below) it goes to the next level in the hierarchy.
- When we click on the drill down for the first time, it displays only the first level hierarchy ( Product and Country).
This is how we can work with clustered column chart drill-down feature in Power BI.
Read How to use weekday function power bi with example
Power BI clustered column chart gridlines
- There are two types of gridlines available in the Power BI, they are,
- Horizontal gridline
- Vertical gridline
- We can choose the line style, line color, and line width for the gridlines. At a time we can enable both the horizontal line and vertical line in the clustered column chart Power BI.
Enable Gridlines in Power BI clustered column chart:
- Intially, select the clustered column chart for which you want to enable the gridlines. Select the Format visual option under the visualizations.
- Under the Visual settings, search for the Gridlines and expand the Gridline and enable the horizontal gridline option.
- Once the horizontal gridline is enabled we can choose the style of the line, the color of the line, and also the width of the line.
- In the below screenshot, you can see that I have enabled the horizontal grid line option and changed the default color to blue. In the clustered column chart, we can see that the horizontal gridlines are enabled.
- In the same way, we can also enable the Vertical gridline, Once the vertical gridline is enabled we can choose the style of the line, the color of the line, and also the width of the line.
- In the below screenshot, you can see that I have enabled the vertical grid line option and changed the default color to blue. In the clustered column chart, we can see that the vertical gridline is enabled.
- We can also reset the values by clicking on the reset to default option.
This is how we can enable the horizontal gridline and vertical gridline in the clustered column chart Power BI.
Read Contact your admin to enable embed code creation Power bi
Power BI clustered column chart data labels
Let us see how can we enable the column chart data labels in Power BI,
- Select the clustered column chart for which you want to enable the data label and choose the data label position.
- Select the Format visual option, under the Visual tab, Scroll down and search for the Data label option, Enable the data label option as shown below:
- Once the data label is enabled, we can see the data displayed in the clustered column chart.
- We can also reset the changed data label position by selecting the reset to the default option.
- Expand the data label option and Under the options, we can change the data label position of the clustered column chart. By default, the data label position will be Auto. They are three types of the data label position available, they are,
- Auto
- Above
- Under
- The below-mentioned screenshot represents the Inside center data label position in Power BI.
- The below-mentioned screenshot represents the Inside base data label position in Power BI.
This is how to configure the data label and set the data label position in the clustered column chart Power BI.
Read Power BI convert hours to minutes
Power BI clustered column chart legend
Let us see how to add a legend in the clustered column chart Power BI,
- Legend represents the second column value in different bar colors, where the axis represents the first column value.
- Select the clustered column chart for which you want to add legend value, In this example, we will see the Sales occurred based on the Product and country.
- For that in the x-axis field, simply drag and drop the Product field and in the Y-axis drag and drop the Sales field as shown below:
- Now, in the legend section simply drag and drop the Country field, and in the below screenshot you can see that the clustered column chart displays the legend value as well.
This is how to add a legend in the clustered column chart Power BI.
Read Power BI convert yyyymmdd to date
Power BI clustered column chart multiple legends
- Multiple legends are not allowed in the Power BI legend section.
- No, adding two or more legends in the clustered column chart in Power BI is impossible. We can only add one column field under the legend section in the clustered column chart Power BI.
- Even if we create a field hierarchy and add that into the legend section also it will take only one column field into the legend.
Power BI clustered column chart tooltip
Let us see how we can enable the tooltip and customize the tooltip on a Power BI clustered column chart.
- Select the clustered column chart from the visualization pane and make sure the source data has been loaded on the Power bi desktop.
- Now, we can add the data field to the tooltip presented under the Visualization pane.
- If the tooltip is not enabled, when you hover over the clustered column chart you cannot see the tooltip order.
- Make sure you have enabled the Tooltips. If not enable the tooltip in the General tab under the Format visual in the visualizations pane as mentioned below:
- In this example, I have added the Product, Country, and Sales to display in the tooltip, And when you hover over the clustered column chart data point, you can see that the tooltip order displays the Product, Country, and Sales values as above.
- We also have an option to format the visuals and to change the Font, label color, and value color of the Tooltip order under the text option.
- Under the Background option, we can change the background color of the tooltip.
- We can also reset the default values, by selecting the rest to the default option.
This is how we can add and customize the tooltip on a Power BI clustered column chart.
Read Get Month Name from Month Number in Power BI
Power BI clustered column chart different filters
Let us see how we can apply a filter in the Power BI clustered column chart,
- In the Power BI filters pane, we can able to apply filters, There are three different types of filters that are available in the filters pane, they are,
- Filters on this visual -> Filters will be applied only for the selected visual.
- Filters on this page -> Filters will be applied on the selected page.
- Filters on all pages -> Filters will be applied on all the pages.
Filters on this visual
- Select the clustered column chart visual for which you want to apply the filter, Expand the filter pane and choose the column fields to apply the filter based on the field value.
- The clustered column visual will automatically change based on the filter applied.
- In this example, I have selected the Product column to filter the data based on the Product for the selected visual.
- You can see that the below screenshot represents the selected product data called Carretera based on the filter applied.
Filters on this Page
- Select the clustered column chart for which you want to apply the filter on the page, Expand the filter pane and choose the column fields to apply the filter based on the field value.
- The clustered column will automatically change based on the filter applied on the page.
- In this example, I have selected the Country column to filter the data based on the country for the page.
- You can see that the below screenshot has a stacked column chart and clustered column chart when I apply a filter under the filters on this page. It filters and displays the data based on the column field for the two charts.
- In the below screenshot, you can see that the filter applied is based on the country under the filter on this page.
- Filters on all pages -> Filters and display the data based on the applied filter on all the reports pages.
This is how we can filter and display the data in the clustered column chart in Power BI, and these are the three different filter types available under the filters pane in Power BI.
Read Power bi shared dataset permissions management
Power BI clustered column chart x-axis label
Let us how we can enable and customize the clustered column chart x-axis label in Power BI,
- Select the clustered column chart, in the right-hand side select the formatting pane under the visualizations.
- Enable the x-axis slider option, when we expand the x-axis, we can find the values and Title option where we can change the font size and font style. We also have an option to customize the color of the text.
- We can also reset the default values, by selecting the Reset to default option.
- When we disable the x-axis slider option, we cannot able to view the x-axis label in the clustered column chart as shown below:
This is how to enable and customize the clustered column chart x-axis label in the Power BI.
Read Power BI nan error (Not a number) while dividing by Zero
Power BI clustered column chart column width
Let us see how we can increase the column width in the clustered column Power BI,
- Select the clustered column chart for which you want to adjust the column width. We can modify the column bar size by increasing or decreasing the inner padding percentage and the Minimum category width.
- By default, the Minimum category width is 20px, we can change or modify the column width up to 180 px.
- Both the inner padding and minimum category width will be 20px by default.
- In this example, I have created a clustered column chart as shown below:
- Select Format Visual under the Visualisation pane, Expand the Columns under the Visual tab (highlighted in Red), and expand the Spacing option -> Minimum category width:
- We also have the chance to reset to the default values by selecting the reset to default option.
- The below screenshot represents the clustered column chart with the increased column width.
This is how we can increase the column width in the clustered column Power BI.
Check out: Stacked Bar Chart in Power BI
Power BI clustered column chart y-axis title
Let us see how we can change the clustered column chart y-axis title in Power BI,
- To enable or disable the Y-axis Title option from On to Off in the clustered column chart we can use the toggle control switch to on/off.
- We can also add the title manually and display them in the clustered column chart Power BI.
- We can choose the font style and font size. In addition, we can choose the Text color, BackGround color and also Text alignment, and Text wrap as mentioned below:
- In the below screenshot, you can see that I have changed the Y-axis title from Sales to Sales based on Product.
- We can also reset the default values, by clicking on the reset to the default option.
This is how to change or customize the clustered column chart y-axis title in Power BI.
Read Power BI report using People Picker Field
Power BI clustered column chart formatting
Let us see how we can format a clustered column chart in Power BI, and also we will see a few examples of formatting the clustered column chart.
- Formatting the Power BI clustered column Chart contains altering the Bar Colors, Title position, Title text, Tooltip, Data labels, etc.
- The formatting visual pane includes two tabs, the first one is a visual tab and the second one is a general tab.
Format clustered column Chart Visual Settings
- Initially select the clustered column chart that you want to format, under the Visualization pane click on the format visual icon. Select the visual tab.
- Under the Visual settings, we can see both Axis details, Legends, Gridlines, Data labels, Plot area background, etc., as highlighted below:
Format X-Axis of a clustered column Chart in Power BI
Let us see how we can format or customize the X-axis clustered column chart in Power BI,
- Based on selected visual and column fields we can see the type, values, title, range, etc., in the X-axis, clustered column chart.
- By default, the X-Axis title will be enabled, if we want to disable it, we can do it by toggling Title to Off.
- Under the Values, we can change the style of the font, font size, font color, height, etc.,
- In the Title section, we can manually enter the title that we want to display on the x-axis and we can change the font style, font size, font color, height, etc., for the title.
- We can also reset the default values, by clicking on the reset to the default option.
- In the below screenshot, you can see that I have changed the default color to the Pink color under the values section.
This is how we can format the X-axis of a clustered column chart in Power BI.
Format Y-Axis of a Power BI clustered column chart
Let us see how we can format or customize the Y-axis clustered column chart in Power BI,
- By default, the Y-Axis title will be enabled, if we want to disable it, we can do it by toggling Title to Off.
- Under Range, we can set the Minimum and Maximum values, we also have an option to enable the Logarithmic scale and invert the range. When we enable these options the clustered column chart changes automatically based on the ranges.
- In the below screenshot, you can see that I have enabled the logarithmic scale, under the range section.
- The logarithmic scale is used to analyze the large range of the quantities with the changes that occurs in data on that axis.
- Under the Values we can change the style of the font, font size, font color, height, etc., In extra, we can also switch the Y-axis position, for that we have to enable the switch position toggle control.
- In the below screenshot, you can see that I have enabled the switch of the Y-axis position under the values section.
- In the Title section, we can manually enter the title that we want to display on the Y-axis and we can change the font style, font size, font color, height, etc., for the title.
- We can also reset the default values, by clicking on the reset to the default option.
- In the below screenshot, you can see that I have changed the title of the Y-axis position under the Title section.
This is how to format or customize the Y-axis clustered column chart in Power BI.
Format clustered column Chart General Settings
- Initially select the clustered column chart that you want to format, under the Visualization pane select the format visual icon. click on the General tab.
- Under the General settings, we can see Title, Properties, Alt text, Tooltips, etc., as highlighted below:
Format Power BI clustered column Chart Properties
Let us see how can we Format Power BI clustered column Chart Properties,
- Under the Properties section, we can change the Position and size of the clustered column chart. Expand the size section to change the height and width of the clustered column chart.
- When we resize the clustered column chart, automatically the height and width will change accordingly.
- Under Position, we can change the vertical and horizontal position of the clustered column chart as highlighted below:
- Select the Reset to default option to revert back the changes that you have made in the properties section.
This is how to Format Power BI clustered column Chart Properties.
Read Power bi table visualization
Format Power BI clustered column Chart Title
Let us see how can we Format Power BI clustered column Chart Title,
- To enable or disable the Title option from On to Off in the clustered column chart we can use the toggle control switch to on/off.
- We can also add the title manually and show them in the clustered column chart Power BI, Also we have an option to choose the headings (heading 2 to heading 6). We can the font style and font size.
- We can also reset the default values, by clicking on the reset to the default option.
- In the below screenshot, you can see that I have changed the Horizontal alignment to the center, and also I have changed the background color and the text color.
- In addition, we can choose the Text color, BackGround color and also the Text alignment, and Text wrap as mentioned below:
This is how to Format Power BI clustered column Chart Title.
These are a few examples to format a clustered column chart in Power BI.
Read Subtraction in Power bi using DAX
Power BI clustered column chart count
Let us see how we can calculate the count in the Clustered column chart in Power BI,
In this example, I am going to calculate the product count that occurred based on the country.
- Select the clustered column chart for which you want to calculate, For that, drag and drop the column fields as mentioned below:
- X-axis – Country
- Y-axis – Product
- Expand the Y-axis product field and choose the count option as highlighted below:
- In the below screenshot, you can see that when we hover over the bar it shows the product count based on the country.
This is how to calculate the count in the Clustered column chart in Power BI.
Read DAX Filter function
Power BI clustered column chart two tables
Let us see how we can show Multiple tables graphed on a single clustered column chart in Power BI,
If we want to show the clustered column chart with two tables, then we have to know about the relationship Cardinality, There are four Cardinality, they are,
- One-to-many (1:*)
- Many-to-one (*:1)
- One-to-one (1:1)
- Many-to-many (*:*)
- Now choose the clustered column chart and in the Model section (highlighted below), Pick the columns and set the relationship.
- Here financials is one table, and Sheet 1 is another table in this example, here I have added many to many relationships.
- Now select the Report section, In the clustered column chart, in the x-axis field drag and drop the product column from the financials table. And in the Y-axis field drag and drop the sales column from the Sheet1 table.
- In the below screenshot, you can see the clustered column charts display the values based on the two different tables.
This is how we can display two tables graphed on a single clustered column chart in Power BI.
Read Get Current Month Sales Report using Power BI Measure
Power BI clustered column chart with line
Let us see how we can display the clustered column with the line in the Power BI,
- Directly, we cannot add the line into the clustered column. So we can choose the Combo chart which is Line and Clustered column chart.
- It is possible to display the clustered column chart with lines in Power BI.
Follow the below steps to achieve this:
- Select the line and clustered column chart, In this example Sales and Profit occurred based on country.
- Simply drag and drop the country field on the x-axis and the Sales field on the Y-axis.
- In the line y-axis, drag and drop the Profit field as mentioned below:
- In the below screenshot, you can see that the Power BI clustered column chart display the visual with line.
This is how to display the clustered column with the line in the Power BI.
Read Export Power BI reports to PDF
Power BI clustered column chart date
Let us see how can we display the data based on the date in clustered Column Chart in Power BI,
In this example, we use a clustered column chart to display the data sales that occurred based on the date.
- Make sure the source data has been loaded into the Power BI desktop, and confirm that the data source has been loaded under the fields.
- Now under the Visualizations pane, select the clustered column Chart option, you can see that the clustered column chart is added to the report canvas.
- For that in the X-axis field drag and drop the Date Hierarchy expand and Choose the date field. And in the Y-axis field drag and drop the Sales field.
- In the below screenshot, you can see the clustered column chart displays the data with multiple years in Power BI based on sales that occurred on the Weekly Date in the report canvas.
This is how to display the data based on the date in the Clustered Column Chart in Power BI.
Read Export Power BI Reports to Excel
Power BI clustered column chart data colors
Let us see how can we show the clustered column chart data colors in Power BI.
- In the Previous version of Power BI, we can see the data color option available separately under the Formatting Pane.
- In the Updated version of Power BI, we cannot see the data color option, instead of that When we expand the columns we can able to change the data color. In the below example I will show you how we can achieve this.
Follow the below-mentioned steps to accomplish this:
- Make sure the data has been loaded into the Power BI desktop, Select the clustered column chart and add it to the report canvas.
- In the X-axis and Y-axis drag and drop the column fields as mentioned below: In this example, I am going to display the clustered column chart with the Sales that occurred based on the Product.
- X-axis – Product
- Y-axis – Sales
- Now to change the data color, select the format visual, under the visual settings Expand the columns option and expand the colors option enable the Show all option as shown below:
- Here we can change the data colors that we want to display in the clustered column chart. By default it will be in sky blue color, we can change the default data color.
- In the below screenshot, you can see that the clustered column chart data color has been changed.
This is how to show the clustered column chart data colors in Power BI.
Read Power BI DAX (Data Analysis Expressions) tutorial
Power BI clustered column charts of different colors
Let us see how to display the clustered column chart with different colors in Power BI,
Yes, by adding the legend we can display the clustered column chart with different colors, and it is also possible to change the default colors in Power BI.
- Select the clustered column chart, In the X-axis and Y-axis drag and drop the column fields as mentioned below: In this example, I am going to display the clustered column chart with the Sales that occurred based on the Product.
- X-axis – Product
- Y-axis – Sales
- Now in the legend section, add the country field. It will randomly take some color and displays the clustered column chart with the different colors.
- If we want to change the default color, we can change it in the Format visual settings.
- In addition, we can also see another option called Small multiples, which splits the visual into multiple parts of itself based on the column field. Here based on the Segment column field I have split the clustered column visual as shown below:
- In the below screenshot, you can see that the clustered column chart is displayed with different colors in Power BI.
This is how to display the clustered column chart with different colors in Power BI.
Read Power BI Change Data Type of a Column
Power BI clustered column chart show zero values
Let us see how we can show the zero values in the Power BI clustered column chart,
- Select the clustered column chart from the Visualization in Power Bi. Ensure the selected column field has a null or zero value in the loaded data source. Sometimes by default, it displays Zero values. If not we have set the value as zero.
- In this example, we use the clustered column chart to see the Discounts based on the Product.
- For that in the x-axis field, drag and drop the Product field and in the Y-axis field drag and drop the Discounts field.
- Now in the format visual pane, expand the Y-axis and select the Range option under the range option set the minimum value is 0.
- Once the minimum value is changed, set the minimum range as 0 and now we can see the below screenshot represents the zero value shown on the Y-axis of the Power Bi line chart.
This is how we can show the zero values in the Power BI clustered column chart.
Read Power BI Error: This content isn’t available
Power BI clustered column chart drill-through
Let us see how we can use the drill-through feature in the Power BI clustered column chart,
- Before that, we will know the drill-through is used to reach the destination page or target page in the report.
- When we add a field to the Drillthrough filters, Power BI automatically creates a back button in the clustered column chart visual.
Follow the below steps to set the drill-through features:
- Select the clustered column chart, in the x-axis field, drag and drop the Product field in the Y-axis field drag and drop the Sales field, and in the legend section drag and drop the country field as mentioned below:
- Now, under the drill-through option enable the cross-report option, and add the drill-through fields in the drill-through section.
- Filters will be applied to all the pages in the report canvas, Now right click on the report canvas and select the Drill through option, and choose the target page.
- Here in this example, I have applied the drill-through feature for Page 1 and selected Page3 as the target report as shown below:
- We can also drill through from Page 3 to Page 1, we can also see the filter applied on both pages. This is how the drill-through feature works.
This is how to use the drill-through feature in the Power BI clustered column chart.
Read Add Title, Image, and Video to Power BI Dashboard
Power BI clustered column chart value and percentage
Let us see how we can show the value and percentage in the Power BI clustered column chart,
- Select the line and clustered column chart from the Visualization in Power BI, In this example, we see the sales and percentages for that in the X-axis field drag and drop the Country field. In Column Y-axis drag and drop the Sales field.
- Now create a measure and apply the below-mentioned formula,
Percentage% = CALCULATE(SUM('financials'[COGS])/CALCULATE(SUM('financials'[ Sales])),ALL(financials[ Sales]))- In the Line y-axis drag and drop the Measure field which is created now as shown below:
- In the below screenshot, you can see that the clustered column displays the value and percentage.
This is how to show the value and percentage in the Power BI clustered column chart.
Read Access to the resource is forbidden error in Power BI
Power BI clustered column chart show only selected data
Let us see how we can display the Power BI clustered column chart based on the selected data,
- In this example, we will use the list slicer to select the data so that based on the selected data, clustered column chart will appear.
Follow the below steps to display clustered column chart based on selected data:
- Initially, add the list slicer and clustered column chart to the Power BI report canvas.
- For that Initially, create a list slicer and make a list slicer and drag the Product field column into that as shown below:
- In the Visualizations pane, select the clustered column chart to create a clustered column chart for the report canvas, and in the x-axis drag and drop the product field and in the y-axis field drag and drop the Sales field like below:
- Now, we can see that the clustered column chart visual data changes according to the selected list slicer value as below: If we select the Paseo product from the list slicer, the clustered column chart also displays the selected data.
This is how to display the Power BI clustered column chart based on the selected data.
Read Power BI Bookmarks
Power BI clustered column chart padding
Let us see how we can resize or adjust the space between bars in the clustered column chart padding Power BI,
- There are two ways that we can adjust space between the clustered column chart bars, One way is directly we can go to the formatting pane -> Columns -> Spacing -> Inner padding.
- Another way that we can adjust the space between the bars is by setting the Measure value as 0.
Follow the below steps to achieve this:
- In this example, we will see the sales that occurred based on the product, For that drag and drop the column fields as shown below:
- X-axis – Product
- Y-axis – Sales
- Now, create a new measure and set the Measure value as 0. After that drag and drop the created measure field into the Y-axis value section as mentioned below:
Measure = 0
In the above screenshot, you can see that the clustered column chart bar is resized, once the measured value is applied.
This is how we can resize or adjust the space between bars in the clustered column chart padding Power BI.
Read Power bi change color based on value
Power BI clustered column chart remove white space
Let us see how we can get rid of the white space in the clustered column chart in Power BI,
Yes, we can remove the white space in the clustered column chart by increasing or decreasing the Inner padding size.
Follow the below steps to remove white space in Power BI clustered column chart:
- Select the clustered column chart for which you want to remove the white space. We can adjust the column bar size by increasing or decreasing the inner padding percentage.
- In this example, I have created a clustered column chart to see the sales that occurred based on the Product as shown below:
- Select Format Visual under the Visualisation pane, Expand the Columns under the Visual tab (highlighted in Red), and expand the Spacing option -> inner padding:
- We can set the inner padding px according to the white space we want to display in the Clustered column chart. If we set the inner padding pixel as 0 then we cannot see the white space in the clustered column chart.
- We also have the chance to reset to the default values by selecting the reset to default option.
- The below screenshot represents the clustered column bar chart with no space in Power BI.
This is how we can get rid of the white space in the clustered column chart in Power BI.
Read Power BI calculated column
Power BI clustered column chart vertical
Intially, we have to know that there are two different clustered charts, One is Clustered bar chart and the other one is Clustered column chart. It
- Clustered bar chart – When we create or add the clustered bar chart visual to the Power BI report canvas, by default it will be displayed in the Horizontal bars.
- Clustered Column chart – When we create or add the clustered column chart visual to the Power BI report canvas, by default it will be displayed in the Vertical bars.
Power BI clustered column chart increases bar width
Let us see how we can increase the clustered column chart bar width in Power BI,
- Select the clustered column chart for which you want to increase the bar width. We can increase the inner padding percentage and the Minimum category width.
- By default, the Minimum category width is 20px, we can change or modify the column width up to 180 px.
- In this example, I have created a clustered column chart as shown below:
- Select Format Visual under the Visualisation pane, Expand the Columns under the Visual tab (highlighted in Red) expand the Spacing option -> Minimum category width.
- We also have the chance to reset to the default values by selecting the reset to default option.
- The below screenshot represents the clustered column chart with the increased column width.
This is how to increase the clustered column chart bar width in Power BI.
Power BI clustered column chart reduces bar width
Let us see how we can reduce the clustered column chart bar width in Power BI,
- Select the clustered column chart for which you want to reduce the bar width. We can decrease the inner padding percentage and the Minimum category width.
- By default, the Minimum category width is 20px, we can change or modify the column width up to 180 px.
- In this example, I have created a clustered column chart as shown below:
- Select Format Visual under the Visualisation pane, Expand the Columns under the Visual tab (highlighted in Red) expand the Spacing option -> inner padding
- We also have the chance to reset to the default values by selecting the reset to default option.
- Set the inner padding 20px to 50px under the Spacing section.
- The below screenshot represents the clustered column chart with the reduced column width.
This is how to reduce the clustered column chart bar width in Power BI.
Power BI clustered column chart by value
Let us see how we can display the clustered column chart by value in Power BI.
- Make sure the data has been loaded into the data set, and add the clustered column chart visual to the Power BI report canvas.
- Axis: Specify the Major Column that represents the X-axis.
- Legend: Specify the second Column that represents Vertical Bars.
- Values: Any Numeric value such as Total Sales, sales amount, etc which represents the Y-axis.
- In this example, I have created a clustered column chart as shown below: In the X-axis field, I have added the Product field which is an unsummarized field.
- In the Y-axis, I have added the Sales field which is the Summarized field that defines Value.
- In the below screenshot, you can see that the clustered column chart displays the data based on the summarized field value.
This is how to display the clustered column chart by value in Power BI.
Read Power BI Group By
Power BI clustered column chart can’t add legend
- In the clustered column chart, when we add Multiple values in the Y-axis field, then we cannot add any column field to the legend section.
- Only, if we add a single column field into the Y-axis field, then it is possible to add the legend to the legend section.
- If we add multiple values in the values section, then it will not allow adding a column field to the legend section.
Power BI clustered column chart grouping
Let us see how we can group the data in the Power BI clustered column chart,
- By default, clustered column chart groups the data from the data set and displays them in the Clustered column chart visual.
- We can also group the data based on the bar chart by right click on the bar, and selecting the Group data.
- In the same manner, we can group the data based on the remaining products as shown below:
- We can edit the groups, by expanding the newly created groups and clicking on the Edit group as mentioned below:
- We can also ungroup, select the product that you want to ungroup and click on the Ungroup, and include another group. Click on the Ok button.
- Once the product is Ungrouped, you can see that the Velo product is changed to the default color.
This is how to group the data in the Power BI clustered column chart.
Read Power bi conditional column
Power BI clustered column chart hides zero values
Let us see how we can remove the zero values in the clustered column chart Power BI,
Yes, it is possible to hide the zero values in the clustered column chart Power BI.
In this example, we will use the slicer to select the data so that based on the selected data, clustered column chart will appear. And also I used the below table for this example which has zero Sales value:
Follow the below steps to hide zero values from the clustered column chart
- Initially, add the slicer and clustered column chart to the Power BI report canvas.
- For that Initially, create a slicer and drag the Sales field column into that as shown below:
- In the Visualizations pane, select the clustered column chart to create a clustered column chart for the report canvas, and in the x-axis drag and drop the Country field and in the y-axis field drag and drop the Sales field like below:
- Now, we can see that the clustered column chart visual data changes according to the selected slicer value as below: If we select the slicer from the 100 sales value, the clustered column chart also displays the data from the 100 and it hides the data below 100.
This is how to remove the zero values from the Power BI clustered column chart.
Read:
- Power BI date hierarchy
- Power BI divides two columns
- Power BI Sum Multiple columns
- Power BI filter between two dates [With 15+ Examples]
In this Power BI Tutorial, we learned What is clustered chart visual is in Power BI and How to create a clustered Chart in Power BI with examples. And also we discuss the below-mentioned topics:
- Power BI clustered column chart multiple X-axis
- Power BI clustered column secondary axis
- Power BI clustered column chart remove a secondary axis
- Multiple values on a clustered column chart in Power BI
- Power BI clustered column chart sort order
- Power BI clustered column chart sorted by year
- Power BI clustered column chart sorted by month
- Power BI clustered column chart sorted by legend
- Power BI clustered column chart color based on the value
- Power BI clustered column chart space between bars
- Power BI clustered column chart add the line
- Power BI clustered column chart average line
- Power BI clustered column chart trend line
- Power BI clustered column chart month and year
- Power BI clustered column chart drill-down
- Power BI clustered column chart gridlines
- Power BI clustered column chart data labels
- Power BI clustered column chart legend
- Power BI clustered column chart multiple legends
- Power BI clustered column chart tooltip
- Power BI clustered column chart different filters
- Power BI clustered column chart x-axis label
- Power BI clustered column chart column width
- Power BI clustered column chart two y-axis
- Power BI clustered column chart y-axis title
- Power BI clustered column chart formatting
- Power BI clustered column chart count
- Power BI clustered column chart two tables
- Power BI clustered column chart with line
- Power BI clustered column chart date
- Power BI clustered column chart data colors
- Power BI clustered column charts of different colors
- Power BI clustered column chart show zero values
- Power BI clustered column chart drill-through
- Power BI clustered column chart value and percentage
- Power BI clustered column chart show only selected data
- Power BI clustered column chart padding
- Power BI clustered column chart white space
- Power BI clustered column chart vertical
- Power BI clustered column chart increases bar width
- Power BI clustered column chart reduces bar width
- Power BI clustered column chart by value
- Power BI clustered column chart can’t add legend
- Power BI clustered column chart grouping
- Power BI clustered column chart hides zero values
I am Bijay a Microsoft MVP (8 times – My MVP Profile) in SharePoint and have more than 15 years of expertise in SharePoint Online Office 365, SharePoint subscription edition, and SharePoint 2019/2016/2013. Currently working in my own venture TSInfo Technologies a SharePoint development, consulting, and training company. I also run the popular SharePoint website EnjoySharePoint.com