Home » Power BI Visuals » Power BI – 100% Stacked Column Chart

Power BI – 100% Stacked Column Chart

100-Stacked-Column-Chart-in-Power-Bi

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

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.

 

Stacked Bar Chart Properties

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:

Stacked Column Chart

Stacked Bar Chart

100% Stacked Bar Chart

Matrix Vs Table

Card Visualization

Multi-row Card Visual

Leave a Reply