In Power BI, 100% Stacked Column Chart will display the metric information in percentages. In this article we will show you, How to Create 100% Stacked Column Chart in Power BI with example.
For this 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 100% Stacked Column Chart in Power BI
In order to create a 100% Stacked Column Chart, 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.
Next, let me add Sales Territory Region Name to Axis section. This Column Chart shows the Sales Amount by Sales Territory Region Name.
Click on the 100% Stacked Column Chart under the Visualization section. This will automatically convert the Column Chart into 100% Stacked Column Chart
Next, we are adding Customer Occupation to Legend section to convert it into the 100% Stacked Column Chart.
Hover over any portion of a bar will show you the Tool-tip of Sales Territory Region Name, Customer Occupation, and Sales Amount (in percentage)
Create 100% Stacked Column Chart in Power BI – Approach 2
First, click on the 100% Stacked Column Chart under the Visualization section. This will automatically create a 100% Stacked Column Chart with dummy data as shown in the below screenshot.
In order to add data to 100% Staked Column Chart, we have to add required fields:
- Axis: Please specify the Column that represent the Verical Bars.
- Legend: Specify the Column to divide the Vertical Bars.
- Values: Any Metric value such as sales amount, Total Sales etc.
Let me drag the Sales Amount from Fields section to Values field, and Sales Territory Region Name field to the Axis Section.
Next, add the English Occupation from DimCustomer table to the Legend section. You can do this by dragging Occupation to Legend section, or simply check mark the English Occupation column
In Power Bi Charts, Data Labels will display the information about each and every individual group of a vertical bar (Sales Territory Region). In this case, it will display the Sales Amount (in percentage) of each occupation. Let me Enable the Data Labels so that you can see the Percentage of each group.
To enable data labels, please go to the Format tab and toggle Data labels option to On. Let me change the Color to White, Font family to DIN, and Text Size to 20
Now you can see a 100% Stacked Column Chart with Percentage values
Let me do some quick formatting to this 100% Stacked Column Chart
NOTE: Formatting options for both Stacked Column Chart and 100% Stacked Column Chart are same. So, I suggest you to refer Format Stacked Column Chart article to understand the steps involved in formatting the 100% Stacked Column Chart properties.
This time, we added State Province Name to Axis, and Sales Territory Region to Legend for 100% stacked column chart. From the below screenshot you can see, Sales Territory Region is acting as the Bar Color. This is because, You can’t group the Sales Territory Region inside a State ( State Name is Inherited from Territory).
Thank You for Visiting Our Blog