Open In App

Power BI – Create 100% Stacked Bar Chart

Improve
Improve
Like Article
Like
Save
Share
Report

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:

dataset

 

Step 1: Click under the home tab,

clicking-home

 

Step 2: Click on Get Data.

clicking-get-data

 

Step 3: Click on Excel Workbook and open the file from the file location.

clicking-excel-workbook

 

Step 4: Select the sheet and click on Load to import.

loading-dataset

 

Step 5: To make a 100% stack bar chart, Under visualization click on Build Visuals.

selecting-build-visuals

 

Step 6: Select the 100% stack bar chart and resize it if needed.

selecting-100%-stacked-bar-chart

 

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.

Adding-data-on-chart

 

To see the Percentage of each bar, Click on Format Visuals.

selecting-format-your-visuals

 

  • Make the Data Label ‘On’.
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.


Last Updated : 17 Feb, 2023
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads