Stacked Column Chart is useful to compare multiple dimensions against a single measure. In a Stacked Column Chart, Axis is represented on X-axis and the data is represented on Y-axis.
So, Let’s start with an example
Step-1: Download Sample data : SuperStoreUS-2015.xlxs
Step-2: Open Power Bi file and drag Stacked Column Chart to Power BI Report page.
Step-3: Click any where on Stacked Column Chart & drag columns to Fields section, see below image for reference.
- Axis: ‘Region’
- Legend: ‘Product Category’
- Value: ‘Sales’
Required Fields descriptions
- Axis: Specify the Column that represent the Vertical Bars.
- Legend: Specify the Column to divide the Vertical Bars.
- Values: Any Numeric value such as Sales amount, Total Sales etc.
Step-4: Set Chart font size, font family, Title name, 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 column 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 column chart.
- Title: Specified the Title name for Chart.
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.