Power BI 100% stacked column chart is used to display relative percentage of multiple data series in Stacked columns, where the total (cumulative) of each Stacked columns always equals 100%.
In a 100% Stacked column chart, Axis is represented on X-axis and Value on Y-axis.
Let’s start with an example
Step 1. Download Sample data : SuperStoreUS-2015.xlxs
Step 2. Open Power Bi file and drag 100% Stacked Column chart into Power BI Report page.
Step 3. Now drag columns to Fields section, see below image for your ref.
- Axis: ‘Region’
- Legend: ‘Product Category’
- Value: ‘Sales’
100% Stacked Column Chart
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 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.
- Title: Specified the Title name for 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: