Saturday, December 30, 2023

Lesson 30 - 100% Stacked Column Chart in Power BI Desktop

A 100% Stacked column chart is a type of visual that displays multiple series of data in vertical columns. Each column represents a category, and the height of the column illustrates the total value of the data in percentage for that category. 
The difference between 100% Stacked column chart with regular Stacked column is that it displays each column as a percentage of the whole, allowing for easy comparison of the relative proportions within each category across different groups or variables.

How to proceed?

Step 1

Launch power BI desktop app and open the new report page and import the data required. 

Refer Lesson 7 - Power BI Datasets to build great visuals

Step 2

In “visualizations” pane click on “100% Stacked Column chart” which is highlighted in the given figure.

Step 3

Drag the data fields into “Field Section” that you want to analyze using 100% Stacked column chart.
X axis: Represent categories or groups that you want to compare - Year

Y axis: Represents numerical value that you want to display within each category or group in X-axis– Number of Participants

Legend: Represents sub-categories within each group displayed on X-axis. Subcategories are visually stacked within each column - Gender.

Step 4

Filters in 100% stacked column chart enable users to selectively focus on specific categories or subcategories of data for deeper analysis.

By filtering the data specifically for the year range from 2000 to 2016, I'm focusing on analyzing information within this defined time period. This selection allows for a more detailed examination of trends, patterns, and insights that occurred between 2000 and 2016, providing a more targeted and precise analysis of the data.

Step 5

Customize the appearance.

You can customize the appearance of the visual.  You can change Title, Font size, Style, Colors and Data labels. Click anywhere on the visual and set the below properties in the Format section.

You are allowed to choose colors for sub-categories to differentiate them. This improves clarity and helps viewers easily identify and understand the distinctions between various sub-categories within your chart, all displayed as percentages relative to the whole.

“Reverse stacked order” option allows you to rearrange the order of data series easily. 

Data labels
represent the exact percentages of each part in the column. These labels provide direct information about the specific contribution of each segment or category to the whole, making it easier for viewers to comprehend and compare the proportions of various components within the chart.

you can customize the orientation, position, and density of the data labels in a 100% stacked column chart. This customization allows you to control how and where the labels appear, their angle or orientation, the precise positioning within or outside the columns, and the density or frequency of these labels. 

Adjusting these settings can help optimize the readability and presentation of the information within the chart, tailoring it to meet specific preferences or requirements.

Step 6

Save the visual

Finally, your 100% Stacked column chart is ready. Click save button to save the visual.

When to use 100% Stacked column chart?

You can use 100% Stacked column chart for following scenarios.

  • When your aim is to visualize and comprehend the distribution of data within each category or group in terms of percentages or proportions.
  • Effective for showcasing how each part contributes to the total across different categories or groups.


  • It enables straightforward comparison of proportions across various categories or groups.
  • Shows how each part adds up to the whole, helping to understand differences and patterns in the data.


  • When dealing with numerous categories or groups, a 100% stacked column chart can become visually complex, potentially making it harder read the information, especially if there are many segments or categories represented in the chart.
  • It does not represent actual values or exact numbers since it focuses more on proportions relative to the whole.


The 100% stacked column chart is great for comparing parts within groups. It shows how each piece makes up the whole as percentages. People in business, finance, marketing, and statistics use it to compare things quickly. It helps to see patterns and differences in data, making it useful for making decisions based on the information.

Tags Power BI
Useful links
MS Learn Modules

Test Your Knowledge


No comments:

Post a Comment