A 100% Stacked Bar chart is a type of visual that displays multiple series of data in horizontal bars. Each column represents a category, and the height of the bar illustrates the total value of the data in percentage for that category.
The difference between 100% Stacked bar with regular bar chart is that it displays each bar 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.
Step 2
In “visualizations” pane click on “100% Stacked bar 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 Bar chart
Y axis: Represent categories or groups that you want to compare - Continent
X axis: Represents numerical value that you want to display within each category or group in X-axis– Medal count
Legend: Represents sub-categories within each group displayed on Y-axis. Subcategories are visually stacked within each bars- Medal
Step 4
Filters in 100% stacked bar chart enable users to selectively focus on specific categories or subcategories of data for deeper analysis.
Here I applied basic filter eliminating NA in continent and for Medals eliminated No medal category
Step 5
Customize the appearance
You can customize the appearance of the visual. You can change Title, Font size, Style, Colours and Data labels. Click anywhere on the visual and set the below properties in the Format section.
You are allowed to choose colours 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 bar. 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 bar 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 bar chart is ready. Click save button to save the visual.
When to use 100% Stacked bar chart?
The main difference between 100% stacked column chart and 100% stacked bar chart is in the orientation (vertical columns vs. horizontal bars) and the way the data is visually presented while it still maintains the concept of a 100% stacked chart where each part contributes to the whole.
The choice between the two types of charts often depends on the specific data and the visual representation that best communicates the intended message.
You can use 100% Stacked bar 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.
Pros
- 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.
Cons
- When dealing with numerous categories or groups, a 100% stacked bar 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.
Conclusion
The 100% stacked bar 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 | Quiz |
No comments:
Post a Comment