Stacked Bar Chart Visual

Microsoft Power BI Stacked Bar Chart is most usable chart in Power BI. It 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.

Refer similar chart: Stacked Column Chart

Prerequisite for this-

Download Power Desktop latest version from – Microsoft Power BI official site

Let’s get started-

Download Sample dataset- Global_superstore_2016.xls

Follow these steps in order to create a stacked bar chart:

Step-1: Load Orders dataset from Global superstore file.




Step-2: Open Power BI file and drag Stacked Bar Chart visual into Power BI Report page.

Step-3: Select Stacked Column Chart & drag some columns into Fields section.

• Axis: ‘Region’
• Legend: ‘Category’
• Value: ‘Sales’

You can see here it is showing single measure for every region with multiple categories in horizontal way, that is use of Stacked Bar chart.

Required Fields descriptions:

• 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.

Format the Stacked Bar Chart visual:

You can set the font size, font family, Title name, X axis, Y axis & Data labels colors for chart visual.




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: Here 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 the values for each category on chart & you can set the display unit, position & orientation of labels.
• Total labels: Enable total summation of categories on top of each bar.
• Zoom Slider: It enables zoom feature on chart, using this you can easily saw the small values on chart.
• Title: Specified the Title name for Chart.

Implement Small multiples feature- Small multiples chart

Refer more Power BI visuals- Power BI Visuals

Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome.