Power BI Stacked Bar chart & Stacked Column Chart both are most usable visuals in Power BI.
Stacked Bar chart is useful to compare multiple dimensions against a single measure. In a stacked bar chart, Axis is represented on Y-axis and Value on X-axis.
Note: Refer 100% Stacked Bar Chart in Power BI.
Let’s start with an example
Step-1: Download Sample data : SuperStoreUS-2015.xlxs
Step-2: Open Power Bi file and drag Stacked Bar chart from Visualization Pane to Power Bi Report page.
Step-3: Click any where on bar chart then go to Format section pane & drag columns to Fields, see below image for your reference.
- Axis: ‘Region’
- Legend: ‘Product Category’
- Value: ‘Sales’
Stacked Bar Chart Power Bi
Required Fields description
- Axis: Specify the Column that represent the Horizontal Bars.
- Legend: Specify the Column to divide the Horizontal Bars.
- Values: Any Numeric value such as Sales amount, Total Sales etc.
Step-4: Set Chart font size, font family, X axis, Y axis & Data labels colors.
Click any where on chart then go to Format Section & set below properties-
- General: Allows you to set X axis, Y axis, width & height of Bar chart.
- Data colors: Using this section you can change the colors used for each series in the chart.
- 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.
- Data labels: Its enable values on bar chart.
Stacked Bar Chart Properties
How to enable Total values for Stacked Chart Visual?
Refer this : Turn on Total labels for Stacked Chart
Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.
Recommended Post: