In Power BI, 100% Stacked Bar Chart will display the metric information in percentages. In this article we will show you, How to Create 100% Stacked Bar 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 Bar Chart in Power BI
In order to create a 100% Stacked Bar 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.
By clicking the 100% Stacked Bar Chart under the Visualization section will automatically convert the Column Chart into 100% Stacked Bar Chart
Next, let me add English Country Region Name to Axis section to create a 100% Bar chart. This Chart shows the Sales Amount (in percentage) by English Country Region Name.
Next, we are adding Occupation to Legend section to convert it into the 100% Stacked Bar Chart.
Hover over any portion of a bar will show you the Tool-tip of Country Name, Customer Occupation, and Sales Amount
Create 100% Stacked Bar Chart in Power BI – Approach 2
First, click on the 100% Stacked Bar Chart under the Visualization section. This will automatically create a 100% Stacked Bar Chart with dummy data as shown in the below screenshot.
In order to add data to 100% Staked Bar Chart, we have to add required fields:
- Axis: Please specify the Column that represent the Horizontal Bars.
- Legend: Specify the Column to divide the Horizontal 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 English Country 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
Data Labels will display the information about each and every individual group of a horizontal bar (country). 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 18
Now you can see a 100% Stacked Bar Chart with Percentage values
Let me do some quick formatting to this 100% Stacked Bar Chart
NOTE: Formatting options for both Stacked Bar Chart and 100% Stacked bar Chart are same. So, I suggest you to refer Format Stacked Bar Chart article to understand the steps involved in formatting the 100% Stacked Bar Colors.
This time, we added State Province Name to Axis, and Country to Legend for 100% stacked bar chart. From the below screenshot you can see, Country Name is acting as the Bar Color. This is because, You can’t group the Country Names inside a State ( State Name is Inherited from Country).
Thank You for Visiting Our Blog