Power BI 100% stacked bar chart is used to display the relative percentage of multiple data series in stacked bars, where each stacked bar’s total (cumulative) always equals 100%. In other words, A 100% stacked bar chart in power bi is a type designed to show the relative chance of multiple data series in stack bars, where the aggregate( accretive) of each stack bar always equals 100. A 100% stack bar chart shows a part-to-whole relationship like a pie chart. Still, unlike a pie chart, a 100% stacked bar chart can show how proportions change over time. 100 Stack Bar Graphs show the chance- of- the- total by conniving the chance of each value to the total quantum in each group. This makes it easier to see the relative differences between amounts in each group.
Steps to Create a 100% Stacked Bar Chart
To create the chart Import the data set to the Power Bi. The dataset used to create a 100% stacked bar chart is here. Below is the screenshot of the same dataset:
Step 1: Click under the home tab,
Step 2: Click on Get Data.
Step 3: Click on Excel Workbook and open the file from the file location.
Step 4: Select the sheet and click on Load to import.
Step 5: To make a 100% stack bar chart, Under visualization click on Build Visuals.
Step 6: Select the 100% stack bar chart and resize it if needed.
Step 7: To fill the data on the chart, Click on Fields and Drag and drop the values as shown below,
Y-Axis: Using this section allows you to modify the appearance of the Y-Axis section of this chart.
X-Axis: Using this section allows you to modify the appearance of the X-Axis section of this chart.
Legend: It is used to specify the Column and divide the Horizontal Bars.
To see the Percentage of each bar, Click on Format Visuals.
- Make the Data Label ‘On’.
Merits and Demerits
This kind of chart is more applicable to use when it’s important to know what the chance breakdown of each order is; as it fluently shows the probabilities composition of each bar. When the bars in the normal stacked bar chart aren’t the same height, as the figures differ, the 100% stacked bar chart can help to compare the probabilities between the bars in a visual way that removes the differences in numbers.
The demerit of a 100% stacked bar chart is that it does not show the total number of each section and it isn’t possible to look at the chart and have a suggestion of how numerous particulars there were in any section. It’s important to suppose about the purpose of the chart before deciding which kind to use.