Power BI Stacked Column Chart is useful to visualize multiple dimensions against a single measure. In this article we will show you, How to Create a Stacked Column Chart in Power BI with 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 Power BI to SQL Server article to understand the Data Source.
How to Create a Stacked Column Chart in Power BI
In order to create a Stacked column Chart in Power BI, first Drag and Drop the Sales Amount from Fields section to Canvas region. This will automatically create a Column Chart as we shown in below.
By clicking the Stacked column Chart under the Visualization section will automatically convert the Column Chart into Stacked Column Chart
Next, let me add Color to Axis section to create a Clumn chart that shows Sales Amount by Color.
Next, we are adding Sales Territory Region Name to Legend section to convert it into the Stacked Column Chart.
Hover over any section of a vertical bar will show you the Tool-tip of Territory, Color, and its Sales Amount
This time, we replaced the Color with State Province Name in Axis Section. From the below screenshot you can see, Territory Region Name is acting as the Bar Color. This is because, You can’t group the Territory inside a State ( State Name is Inherited from Territory).
Hover over any vertical bar will show you the Tool-tip of State Name, Territory, and its Sales Amount
Create a Stacked Column Chart in Power BI Approach 2
First, click on the Stacked Column Chart under the Visualization section. This will automatically create a Stacked Column Chart with dummy data as shown in the below screenshot.
In order to add data to Power BI Staked Column Chart, we have to add required fields:
- Axis: Please 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.
Let me drag the Sales Amount from Fields section to Values field, and Color field to the Axis Section.
Next, add the Sales Territory Region Name from DimSalesTerritory table to the Legend section. You can do this by dragging Territory to Legend section, or simply check mark the Sales Territory Region Name column
Let me do some quick formatting to this Power BI Stacked Column Chart
NOTE: I suggest you to refer Format Stacked Column Chart article to understand the steps involved in formatting the Stacked Column Colors, Title etc.
Thank You for Visiting Our Blog