Stacked Column Chart in Power BI

Power BI Stacked Column Chart is useful to visualize multiple dimensions against a single measure. Let me show you how to Create a Stacked Column Chart with an example.

For this Power BI Stacked Column Chart demonstration, we are going to use the SQL Data Source that we created in our previous article. So, Please refer Connect to SQL Server article to understand the Data Source in Power BI.

How to Create a Stacked Column Chart in Power BI

To create a Stacked Column Chart in Power BI, drag and Drop the Sales Amount from the Fields section to the Canvas region.

It automatically creates a Column Chart.

Stacked Column Source 1

By clicking the Stacked column Chart under the Visualization section, it automatically converts the Column Chart into Stacked Column Chart.

Stacked Column Axis and Values 2

Next, let me add Color to the Axis section to create a Column chart that shows the Sales Amount by Color.

Add Fields to Stacked Column 3

Next, we are adding the Sales Territory Region Name to the Legend section to convert it into the Stacked Column Chart.

Add Legend to Stacked Column 4

Hover over any section of a vertical bar shows the Tool-tip of Territory, Color, and its Sales Amount.

Stacked Column Chart in Power BI 5

We replaced the Color with the State Province Name in Axis Section this time. From the screenshot below, you can see Territory Region Name is acting as the Bar Color. You can’t group the Territory inside a State ( State Name Inherited from Territory).

Stacked Column Chart in Power BI 6

Hover over any vertical bar shows the Tool-tip of the State Name, Territory, and its Sales Amount.

Stacked Column Chart in Power BI 7

Create a Stacked Column Chart in Power BI Approach 2

First, click on the Stacked Column Chart under the Visualization section. It creates a Stacked Column Chart with dummy data.

Stacked Column Chart in Power BI 8

To add data to the Power BI Stacked Column Chart, we have to add the required fields:

  • Axis: Please specify the Column that represents the Vertical Bars.
  • Legend: Specify the Column to divide the Vertical Bars.
  • Values: Any Numeric value such as sales amount, Total Sales, etc.

Let me drag the Sales Amount from the Fields section to the Values field and the Color field to the Axis Section.

Stacked Column Chart in Power BI 9

Next, add the Sales Territory Region Name from the DimSalesTerritory table to the Legend section. You can do this by dragging Territory to the Legend section or simply checkmark the Sales Territory Region Name column.

Stacked Column Chart in Power BI 10

Let me do some quick formatting to this Stacked Column Chart

NOTE: I suggest you refer to the Format Stacked Column Chart article to understand the steps involved in formatting the Stacked Column Colors, Title, etc.

Stacked Column Chart in Power BI 11

About Suresh

Suresh is the founder of TutorialGateway and a freelance software developer. He specialized in Designing and Developing Windows and Web applications. The experience he gained in Programming and BI integration, and reporting tools translates into this blog. You can find him on Facebook or Twitter.