The Power BI 100% Stacked Bar Chart displays the metric information in percentages. Let me show you how to create a 100% Stacked Bar Chart in Power BI with example.
For this Power BI 100% Stacked Bar Chart demonstration, we are going to use the SQL Data Source that we created in our previous article. So, Please refer to Connect Power BI to SQL Server article to understand the Power BI Data Source.
How to Create 100% Stacked Bar Chart in Power BI
To create a Power BI 100% Stacked Bar Chart, first Drag and Drop the Sales Amount from Fields section to Canvas region. It automatically creates a Column Chart, as we shown below.
By clicking the 100% Stacked Bar Chart under the Visualization section automatically convert the Column Chart into 100% Stacked Bar Chart
Next, let me add the 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 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. It automatically creates a 100% Stacked Bar Chart with dummy data, as shown in the below screenshot.
To add data to the100% Stacked Bar Chart, we have to add required fields:
- Axis: Please specify the Column that represents 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 the Fields section to the Values field and English Country Region Name field to the Axis Section.
Next, add the English Occupation from the DimCustomer table to the Legend section. You can do this by dragging Occupation to Legend section, or simply checkmark the English Occupation column.
Data Labels display information about each group of a horizontal bar (country). In this case, it displays 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 Power BI 100% Stacked Bar Chart
NOTE: Formatting options for both Stacked Bar Chart and 100% Stacked bar Chart are the same. So, I suggest you refer to the 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 a 100% stacked bar chart. From the screenshot below, you can see Country Name is acting as the Bar Color. It is because You can’t group the Country Names inside a State ( State Name Inherited from Country).