Stacked Bar Chart in Power BI [With 27 Real Examples]

In this Power BI Tutorial, we will learn how we can use the Stacked bar chart in the Power BI report and why we select the stacked bar chart visual apart from other visualizations in Power BI.

To learn more about this, follow the below headings that I have covered in this Power BI tutorial.

1. What is the Power BI Stacked bar chart
2. How to create a stacked bar chart in Power BI
3. Power BI Stacked bar chart vs Clustered bar chart
4. Power BI stacked bar chart Multiple axes
5. Power BI stacked bar chart with Multiple Measures
6. Power BI stacked bar chart with Multiple values
7. Power BI stacked bar chart legend
8. Power BI stacked bar chart multiple legends
9. Power BI stacked bar chart legend limit
10. Power BI stacked bar chart change legend order
11. Power BI stacked bar chart legend filter
12. Power BI stacked bar chart tooltip
13. Power BI Stacked bar chart show value and percentage
14. Power BI stacked bar chart sort
15. Power BI stacked bar chart conditional formatting
16. Power BI stacked bar chart data label
17. Power BI stacked bar chart average line
18. Power BI stacked bar chart by the group
19. Power BI stacked bar chart from two tables
20. Power BI stacked bar chart filters
21. Power BI stacked bar chart increases bar width
22. Power BI stacked bar chart by date
23. Power BI stacked bar chart by month
24. Power BI stacked bar chart drill down
25. Power BI stacked bar chart y-axis interval
26. Power BI percentage stacked bar chart
27. Power BI stacked bar chart show zero values
28. Stacked bar chart Power BI show total

What is the Power BI Stacked bar chart?

• The stacked bar chart is used to compare Multiple dimensions against a single measure.
• In the Stacked bar chart, the data value will be represented on the Y-axis and the axis represents the X-axis value.
• In this example, we use the SharePoint List as the data source to demonstrate the stacked bar chart in Power BI.

How to create a stacked bar chart in Power BI

Let us see how to create a stacked bar chart in Power BI, and also we will see how we can connect the SharePoint list data source to the Power BI desktop.

• Initially, Open the Power BI Desktop, under the Home section, Select the Get data option presented in the toolbar to connect the Data Source, and then click on the Online Services and choose the SharePoint Online list.
• In this example, I have selected the SharePoint list as my data source, we can also connect the data source from SQL Server, Excel workbook, etc.,

• Now paste the SharePoint List site URL, here under implementation we can see two options, 2.0 and 1.0.
• Before that, we have to know the SharePoint Online list, by default, it has an additional column (like ID, Modified by, etc.,)
  • 2.0 – In advanced settings view mode, Either we can choose all internal columns from the SharePoint list view or the default view from the SharePoint list.
  • 1.0 – If we choose the 1.0 implementation, then by default it takes all the columns from the SharePoint Online list view.
• Here, in this example, I have selected the default view as shown below: Once the View mode is selected click on the Ok button.

• Now select the SharePoint list that you want to connect with Power BI and click on the load option to load the data source into Power BI.

• 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 SharePoint list.
• Under the Visualizations pane, select the Stacked barChart option, and you can see that the Stacked bar chart is added to the report canvas.

• In this example, we use a stacked bar chart to see the sales that occurred based on the country, for that in the X-axis field drag and drop the Country field. And in the Y-axis field drag and drop the sales field.
• The screenshot below shows that the stacked bar chart displays the value based on the Sales by country in the Power BI report canvas.

This is how we can create a stacked bar chart visual in Power BI.

Also read, Power BI Bookmarks [With 21 Examples]

Power BI Stacked bar chart vs Clustered bar chart

Let us see what is the difference between a stacked bar chart and a clustered bar chart in Power BI.

For every report and dashboard, we use the two most basic charts which are column charts and bar charts in Power BI. There are generally two types of these charts i.e. Stacked charts, and Clustered charts. 

Power BI Stacked bar chart

• The stacked bar chart is used to compare the total and values of the sub-categories, now select the Stacked bar chart, here we will see the sales that occurred based on the product, for that in the x-axis field drag and drop the Sales field value and in the Y-axis drag and drop the product field value.
• In the stacked chart, we can only choose the Constant line, we cannot apply the min line, max line or average line, etc.,

• Now in the legend section add the country field to it, in the below screenshot you can see that the stacked bar chart displays the chart with the subcategories value.

Power BI Clustered bar chart

• The Clustered bar chart is used to compare the total and values of all the categories and the sub-categories, now select the Clustered bar chart, here we will see the sales that occurred based on the product, for that in the x-axis field drag and drop the Sales field value and in the Y-axis drag and drop the product field value.
• In the Clustered chart, we can apply the min line, max line or average line, constant line, etc.,

• Now in the legend section add the country field to it, in the below screenshot you can see that the stacked bar chart displays the chart with the subcategories value.

These are the differences between a stacked bar chart and a clustered bar chart in Power BI.

Check out: Power BI calculated column [With 71 Useful Examples]

Power BI stacked bar chart Multiple axes

Let us see how we can display the Power BI stacked bar chart with Multiple axes,

In this example, we use the stacked bar chart to display the Profit and sales that occurred based on the Product. To achieve this, follow the below-mentioned steps:

• Initially, make sure the data source has been loaded to the Power BI report canvas and select the Stacked bar chart and add it to the report canvas as shown below:
  • X-axis – Profit and Sales
  • Y-axis – Product

• In the below screenshot, you can see that the stacked bar chart displays the Profit data with Multiple axes.

• We can also see that the stacked bar chart displays the Sales data with Multiple axes as shown below:

This is how we can display the stacked bar chart with the two x-axis values in Power BI.

Also, read: Clustered Column Chart in Power BI [With 45 Real Examples]

Power BI stacked bar chart with Multiple Measures

Let us see how we can show the multiple measures on the stacked bar chart in Power BI,

In this example, I have created two measures to calculate the total sale and average that occurred based on the country,

• Initially, select the Stacked bar chart and add it to the report canvas, here create two separate measures for Total sales and Average as shown below:
• Select a New measure, and apply the below-mentioned formula to calculate the total sales:

Total Sales = SUM('Financial Sample'[ Sales])

• Now create another New measure, and apply the below-mentioned formula to calculate the Average: Click on the Check-In icon to save the measure.

Average = AVERAGEX('Financial Sample','Financial Sample'[ Sales]+'Financial Sample'[COGS])

• Once the measure is saved, we can see the measure in the calculated symbol under the field section as shown below:

• Now drag and drop the created measures in the x-axis field, just like the column field. And in the Y-axis field drag and drop the Country column field as shown below:

• In the below screenshot, you can see that the stacked bar chart displays the Total sales data with Multiple Measures.

• In the below screenshot, you can see that the stacked bar chart displays the Average data with Multiple Measures.

This is how to show the multiple measures on the stacked bar chart in Power BI.

Power BI stacked bar chart with Multiple values

Let us see how can we display the stacked bar chart with the Multiple values in Power BI,

In this example, we use a stacked bar chart to see the Total sales that occurred based on the Product and country.

• Make sure the source data has been loaded into the Power BI desktop. Now under the Visualizations pane, select the stacked bar chart option, you can see that the 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 show multiple values in the clustered chart.
•  For that in the X-axis field drag and drop the Total sales measure, and in the Y-axis field drag and drop the Product and Country field as highlighted below:

• Now, select the drill-down feature to display clustered column chart data with the multiple values as indicated above:

This is how to display the stacked bar chart with the Multiple values in Power BI.

Check out this post: Power bi change color based on value [With 13 real examples]

Power BI stacked bar chart legend

Let us see how to add a legend in the stacked bar chart Power BI,

• Legend represents the second field value with different bar colors, where the axis represents the first column field value.
• Select the stacked bar chart for which you want to add legend value, In this example, we will see the Total Sales that occurred based on the Product and country.
• For that in the drag and drop the column field values as shown below:
  • X-axis – Total Sales
  • Y-axis – Country

• Now, in the legend section drag and drop the Product field, and below the screenshot, we can see that the stacked bar chart displays the legend value with different bar colors.

This is how to add a legend in the Power BI stacked bar chart.

Power BI stacked bar chart legend limit

Let us discuss the Power BI stacked bar chart legend limit,

• In the Power BI desktop, it is not possible to add multiple column fields in the legend section, we can add only one column field in the legend section for all the visualizations.
• There is no option for you to increase the limitation on the number of legends.
• For example, if we add Sales or Gross Sales value to the legend section, then we can see the  “I icon” at the top of the stacked bar chart.

• Due to many values, the legend section is not accepting that column field. The only option is can change or choose another column field that has minimum data to display in it.
• If the column field has so many values, then it will not display all the data that is presented in the selected column section.
• And there is also no way to increase the legend limit in the Power BI.

The above-discussed points explain the legend limit in the Power BI stacked bar chart.

Also, read: Line Chart in Power BI [Complete Tutorial with 57 Examples]

Power BI stacked bar chart multiple legends

• Multiple legends are not allowed in the Power BI legend section.
• No, adding two or more legends in the stacked bar chart in Power BI is unattainable. We can only add one column field under the legend section in the stacked bar 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 section.

Power BI stacked bar chart change legend order

Let us see how we can sort or order the stacked bar chart based on the legend section in Power BI,

Before that, we have to know that we can only add one legend into the legend section, Multiple legends are not allowed in the legend section.

• Select the stacked bar chart that you want to sort based on the product, In this example, the stacked bar chart displays the Total Sales that occurred based on the Product and country as shown below:
• In the legend section, simply drag and drop the Product field.

• Select the stacked bar chart and select the ellipsis in the upper right corner.
• Now choose the Sort Legend and choose the legend data field which is the Product field.
• The below screenshot represents sorted the legend Product field data in the ascending form (ie, A to Z form).

The below screenshot represents sorted the legend Product field data in the descending form (ie, Z to A form).

This is how we can order and sort the stacked bar chart based on the legend section in Power BI.

Read: Power BI sync slicers [With 15 useful examples]

Power BI stacked bar chart legend filter

Let us see how to apply a primary filter and advanced filter for the legend column field in the Power BI stacked bar chart,

• In this example, we will see both the basic and advanced filters for the legend field in Power BI. You can see that here I have used the Stacked bar chart to calculate the total sales that occurred based on the Country and Product.
• For that in the drag and drop the column field values as shown below:
  • X-axis – Total Sales
  • Y-axis – Country
• Now, in the legend section drag and drop the Product field, and below the screenshot, we can see that the stacked bar chart displays the legend value with different bar colors.

Basic Filtering

• Currently, we will see how to apply basic filtering for the legend in the stacked bar chart Power BI.
• To apply the filter, initially Expand the filter section, and expand the legend section column field. In this example, it is the Product column field.
• Choose the Filter type as Basic filtering as shown below, and we select the product that we want to filter. In this example, I have applied filters for the products called Carretera and Montana.

• In the below screenshot, we can see that the legend basic filter has been applied and displays the selected value in the stacked bar chart visual in Power BI.

This is how to apply the basic filter for the legend field section in the Stacked bar chart Power BI.

Advanced Filtering

• Currently, we will see how to apply Advanced filtering for the legend in the stacked bar chart Power BI.
• To apply the filter, initially Expand the filter section, and expand the legend section column field. In this example, it is the Product column field.
• Choose the Filter type as Advanced filtering as shown below, and we select the product that we want to filter. In an advanced filter, it filters the field value based on the condition that the value contains, does not contain, is blank, etc.,
• Once the condition is applied, choose the apply filter option. If we want to clear the filter then we can simply select the clear filters option.
• In this example, I have applied filters condition for the products that contain either VTT or the product that contains Velo.

• In the below screenshot, we can see that the legend advanced filter has been applied and displays the selected value in the stacked bar chart visual in Power BI.

This is how to apply the advanced filter for the legend field section in the Stacked bar chart Power BI.

This is how to apply a basic filter and advanced filter for the legend column field in the stacked bar chart Power BI.

Check out: Power BI Group By [With 51 real examples]

Power BI stacked bar chart Tooltip

Let us see how we can add and customize the tooltip on a Power BI stacked bar chart,

• Make sure the source data has been loaded on the Power bi desktop, and select the stacked bar chart from the visualization pane.
• Now, we can add the data field to the tooltip presented under the Visualization pane.
• If the tooltip is not enabled, when we hover over the stacked bar chart we cannot see the tooltip order.
• We have to make sure that we have enabled the tooltip option. 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 Profit and discounts data field to display in the tooltip, And when we hover over the stacked bar chart data point, we can see that the tooltip order displays the Profit and discount values as shown below:

• 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 stacked bar chart.

Power BI Stacked bar chart show value and Percentage

Let us see how we can display the stacked bar chart with the value and percentage in Power BI,

• In this example, we will see the sales value and percentage that occurred based on the country, and it is also possible to display the percentage value in the tooltip of the Stacked bar chart in Power BI.
• Select the stacked bar chart, In the x-axis field drag and drop the Sales field value, and In the Y-axis drag and drop the Country field value.
• Now create a measure and apply the below-mentioned formula,

Percentage = CALCULATE(SUM('Financial Sample'[COGS])/CALCULATE(SUM('Financial Sample'[ Sales])),ALL('Financial Sample'[ Sales]))

• After that, add the created measure data field percentage value to the tooltip presented under the Visualization pane.

• In the below screenshot, you can see that the clustered column displays the Sales value and the percentage.

This is how to show the value and percentage in the Power BI Stacked bar chart.

Also, read: Power bi conditional column [With 17 Useful Examples]

Power BI stacked bar chart sort order

Let us see how we can sort and order the stacked bar chart in Power BI,

• Select the stacked bar chart that you want to sort or order, In this example, the stacked bar chart displays the Sales that occurred based on the Product as shown below:

• Select the stacked bar chart and select the ellipsis in the upper right corner of the bar chart.
• Now choose the Sort axis and choose the field value that you want to sort, either we can sort the data based on the X-axis or we can sort the data based on the Y-axis.
• In this example, I have sorted the data based on the X-axis, so the stacked bar chart appears according to the total sales count value.
• The below screenshot represents sorted the axis Sales field data in the ascending form (ie, A to Z form).

The below screenshot represents sorted the axis Sales field data in the descending form (ie, Z to A form).

This is how to sort and order the stacked bar chart in Power BI.

Power BI stacked bar chart conditional formatting

Let us see how we can apply conditional formatting on the Power BI stacked bar chart based on the value,

In this example, we use a stacked bar chart to see the sales that occurred based on the Product,

• Here, if the sales value is less than 1,00,00,000 the stacked bar displays a mild pink color.
• If the sales value is greater than 1,00,00,000 and less than 2,50,00,000 then the stacked bar displays a mild blue color.
• If the sales value is greater than 2,50,00,000 and less than 4,00,00,000 then the stacked bar displays brown color.

To achieve this follow the below-mentioned steps:

• Make sure the source data has been loaded to the Power BI desktop.
• Now under the Visualizations pane, click on the stacked bar chart option, you can see that the stacked bar chart is added to the report canvas and resize it.

• Select Format Visual under the Visualisation pane, Expand the bar 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 Custom value or choose the default values by like Highest Value, Middle value, and the lowest value.
• In this example, I have selected the custom values, so based on that values the stacked bar chart will appear.
• Click on the Ok button to apply the conditional formatting for the stacked bar chart.

In the below screenshot, we can see that the Column chart has been formatted based on the Values.

This is how to apply conditional formatting on the Power BI stacked bar chart based on the value.

Also read: Power BI date hierarchy [With 21 real examples]

Power BI stacked bar chart data label

Let us know how we can configure the data label and set the data label position in the stacked bar chart Power BI.

To set the data label position follow the below-mentioned steps:

• Select the Power BI stacked bar chart for which you want to enable the data label and set the position for it. Now choose 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 stacked bar chart.

• Expand the data label option and Under the options, we can change the data label position of the stacked bar chart. By default, the data label position will be Auto.
• They are five types of the data label position available, they are,
  • Auto
  • Inside end
  • Outside end
  • Inside center
  • Inside base

• We can also reset the changed data label position by selecting the reset to the default option.
• The below-mentioned screenshot represents the Inside center data label position in the Stacked bar chart Power BI.

• The below-mentioned screenshot represents the Outside end data label position in the Stacked bar chart Power BI.

This is how we can configure the data label and set the data label position in the Stacked bar chart Power BI.

Power BI stacked bar chart average line

• No, the average line is not supported in the stacked bar chart of Power BI. In the analytics pane, we can only see the Constant line which is supported in the Stacked bar chart.
• The average line is supported in the Clustered bar chart in Power BI, but not in the Stacked bar chart.

Power BI stacked bar chart by group

Let us see how we can group and ungroup the data in the Power BI stacked bar chart,

• By default, the stacked bar chart groups the data from the data set and displays them in the stacked bar chart visual.
• We can also group the data based on the selected bar by right-clicking on the bar and selecting the Group data option.

Follow the below steps, to achieve this:

• In this example, we will see the sales that occurred based on the country and we will group the data accordingly. Here in the Y-axis – Sales field and in the Y-axis – Country field.
• Here I have selected the Mexico country and right-clicked on the bar to select the Group data option as shown below:

• It automatically creates a group and adds to the legend section as shown below, If you have added any legend field previously then in that case you cannot see the group data option.

In the same manner, we can group the data based on the remaining countries as shown below:

• We can edit the groups, by expanding the newly created groups which will be available in the legend section, and clicking on the Edit group as mentioned below:

• We can also ungroup the data, select the country that you want to ungroup and click on the Ungroup, and include another group. Click on the Ok button.

• Once the Country is Ungrouped, you can see that the country had been changed to the default color and it will come under the other groups as mentioned below:

This is how we can group the data in the Power BI stacked bar chart.

Check: Power BI Date Slicer [With 41 real examples]

Power BI stacked bar chart from two tables

Let us see how we can show Multiple tables graphed on a single stacked bar chart in the Power BI,

If we want to show the stacked bar chart with two tables, then we have to know about the Cardinality relationship, There are four Cardinality relationships available, they are,

1. One-to-many (1:*)
2. Many-to-one (*:1)
3. One-to-one (1:1)
4. Many-to-many (*:*)

• Now Select the stacked bar chart and in the Model section (highlighted below), Pick the columns and initiate the relationship.
• Here Financial Sample is one table, and financials is another table in this example, here I have selected many to many relationships.

• Now select the Report section, In the stacked bar chart, in the x-axis field drag and drop the Country column from the Financials Sample table. And in the Y-axis field drag and drop the sales column from the financials table.

• In the below screenshot, we can see the stacked bar displays the values based on the two different tables.

This is how we can display two tables graphed on a single stacked bar chart in Power BI.

Power BI stacked bar chart filters

Let us see how we can apply a filter in the Power BI stacked bar chart,

• We can able to apply filters on the Power BI filters pane, 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

In this example, I have selected the Country column to filter the data based on the Country for the selected visual.

• Select the  Stacked bar 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 Stacked bar chart visual will automatically change based on the filter applied.
• We can see that the below screenshot represents the selected country field data called France and Mexico based on the filter applied.

Filters on this Page

• Open the report page for which you want to apply the filter, then Expand the Filters pane and under the Filters on this page section drag and drop the field that we want to filter based on the column.
• The Report page will automatically change based on the applied filter.
• In this example, I am going to filter the data based on the filters on this page, here you can see that I am going to filter the data based on the country as shown below:
• The below screenshot represents the data based on the filter applied, it displays data for the selected country only for the selected report page.

Filters on all pages -> Filters and display the data on all the reports pages.

This is how we can filter and display the data in the stacked bar chart Power BI, and these are the three filter types available under the filters pane in the stacked bar chart Power BI.

Power BI stacked bar chart increases bar width

Let us see how we can increase the bar width in the stacked bar chart Power BI,

• Select the stacked bar chart for which you want to adjust the bar width. We can modify the 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 bar 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 stacked bar chart as shown below:

• Select Format Visual under the Visualisation pane, Expand the Bars 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 stacked bar chart with the increased column width.

This is how we can increase the bar width in the stacked bar chart in Power BI.

Also, see this post: Power BI split column [With 13 real examples]

Power BI stacked bar chart by date

Let us see how can we display the Sales data that occurred based on the date field in the stacked bar 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 stacked bar chart option, you can see that the stacked bar chart is added to the report canvas.
• For that in the Y-axis field drag and drop the Date Hierarchy expand and Choose the date field. And in the X-axis field drag and drop the Sales field.

• In the below screenshot, you can see the stacked bar chart displays the data with multiple years in Power BI based on sales that occurred on the Date in the report canvas.

This is how to display the Sales data based on the date in the stacked bar Column Chart in Power BI.

Power BI stacked bar chart by month

Let us see how can we show the sales data by month in the stacked bar chart visual in Power BI,

In this example, we use a stacked bar chart to see the sales that occurred based on the Month, for that in the Y-axis field drag and drop the date hierarchy field. And in the X-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 stacked bar chart option, you can see that the bar chart is added to the report canvas.
• Then click on the drill down icon, to show the sales that occurred based on the monthly data in the stacked bar chart.

• In the below screenshot, you can see that the stacked bar chart displays the Sales that occurred based on the Month in the Power BI report canvas.

This is how we can show the Sales data that occurred by month in the Stacked bar chart visual Power BI.

Power BI stacked bar chart drill down

Now we will discuss how we can work with the stacked bar chart drill-down feature in Power BI.

• Drill requires a hierarchy, when there is no hierarchy in the stacked bar chart visual then we cannot see the drill icons presented in the visual.
• 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 stacked bar chart visual and select the show next level or drill-up option.
• Prefer the Up arrow to drill up to the earlier level of the stacked bar chart hierarchy and the double down arrow to the next level of the stacked bar chart hierarchy.

Follow the below-mentioned steps to show drill-up and drill-down features:

• Select the stacked bar chart and add it to the Power BI report canvas, In this example, we will use the bar chart to see the Sales that happened based on the year, Quater and Month with the hierarchy.
• For that, In the x-axis field drag and drop the Sales column field and in the Y-axis drag and drop the Date hierarchy column field as shown below:

• For example, if we have a hierarchy of Year, Quarter, Month, and day. Initially, when we click on the drill down, it displays only the first level hierarchy ( Year and Quarter).

• When we click on the drill down for the second time, it displays only the second level hierarchy ( Year, Quarter, and Month).

This is how to work with stacked bar chart visual drill down in Power BI.

Power BI percentage stacked bar chart

Let us how we can display the Percentage stacked bar chart in Power BI with easy steps:

Step 1:

• Create a stacked bar chart. For example, here the chart visualizes the data as sales by product and country. We have taken the field as:
  • Y-Axis: Product
  • Legend: Country
  • X-Axis: Sales
• Make sure to turn ON the data label on the formatting pane, so that the stacked bar looks like the below:

Step-2:

Expand the drop-down of Sales(on X-axis field) > Show value as > select Percent of Grand total.

Then the stacked bar chart visual will appear with percentages as shown below:

This is how to display the Percentage stacked bar chart in Power BI.

Power BI stacked bar chart y-axis interval

Let us see how we can change the Y-axis interval in the stacked bar chart Power BI,

We can customize the Y-axis interval like 1000,1200,1400 and so on. We can easily fix the Y-axis range to set the custom interval. To achieve this follow the below-mentioned steps:

• Select the stacked bar chart for which you want to set the interval, Under the format, visual pane.
• Expand the Y-axis, In the range section set the range values that you want to display in the stacked bar chart. We also have an option to reset to the default values.

• In this example, I have set the interval’s minimum range value as 1000 and the maximum range value as 2000 under the Y-axis range section.
• In the below screenshot, you can see that the intervals are set between 1000 to 2000 in the stacked bar chart:

This is how to change the Y-axis interval in the stacked bar chart Power BI.

Power BI stacked bar chart show zero values

Let us see how we can show the zero values in the Power BI stacked bar chart,

• Select the stacked bar 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 stacked bar chart to see the Profit based on the Country and Sales.
• For that in the x-axis field, drag and drop the Profit field and in the Y-axis field drag and drop the Discounts field, and in the legend section drag and drop the Country 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 stacked bar chart.

This is how we can show the zero values in the Power BI stacked bar chart.

Read: Power Query Date [With 31 real examples]

Stacked bar chart Power BI show total

Let us see how we can show the total that occurred based on the product in the Stacked bar chart Power BI.

In this example, we are going to calculate the total sales that occurred based on the product, we can easily calculate it by using measures.

• Initially create a measure and apply the below formula, where we calculated the total sales value based on the unit sold and sales price.

Total Sales = CALCULATE(SUM('Financial Sample'[Units Sold])* SUM(financials[Sale Price]))

• Now select the stacked bar chart, in the Y-axis field drag and drop the Product column field and in the X-axis field drag and drop the created measure field called Total sales as mentioned below:

In the below screenshot, you can see that the stacked bar chart displays the total sale value based on the product as mentioned below:

This is how to show the total that occurred based on the product in the Stacked bar chart Power BI.

Also, you may like some more Power BI tutorials:

• Power BI Sum Multiple columns
• Power Query Examples
• Power BI filter between two dates [With 15+ Examples]
• Power BI divides two columns
• Create table using Power Query in Power BI
• Power BI integration with PowerApps Portals
• Power BI if date + 27 Examples
• Power BI IF + 31 Examples

In this Power BI Tutorial, we learned What is stacked bar chart visual is in Power BI and How to create a stacked bar chart in Power BI with examples. And also we discuss the below-mentioned topics:

• Power BI Stacked bar chart vs Clustered bar chart
• Power BI stacked bar chart Multiple axes
• Power BI stacked bar chart with Multiple Measures
• Power BI stacked bar chart with Multiple values
• Power BI stacked bar chart legend
• Power BI stacked bar chart multiple legends
• Power BI stacked bar chart legend limit
• Power BI stacked bar chart change legend order
• Power BI stacked bar chart legend filter
• Power BI stacked bar chart tooltip
• Power BI Stacked bar chart show value and percentage
• Power BI stacked bar chart sort
• Power BI stacked bar chart conditional formatting
• Power BI stacked bar chart data label
• Power BI stacked bar chart average line
• Power BI stacked bar chart by the group
• Power BI stacked bar chart from two tables
• Power BI stacked bar chart filters
• Power BI stacked bar chart increases bar width
• Power BI stacked bar chart by date
• Power BI stacked bar chart by month
• Power BI stacked bar chart drill down
• Power BI stacked bar chart y-axis interval
• Power BI percentage stacked bar chart
• Power BI stacked bar chart show zero values
• Stacked bar chart Power BI show total