Create 100% Stacked Bar Chart in Power BI

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.

Create 100% Stacked Bar Chart in Power BI 1

By clicking the 100% Stacked Bar Chart under the Visualization section automatically convert the Column Chart into 100% Stacked Bar Chart

Create 100% Stacked Bar Chart in Power BI 2

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.

Create 100% Stacked Bar Chart in Power BI 3

Next, we are adding Occupation to Legend section to convert it into the 100% Stacked Bar Chart.

Create 100% Stacked Bar Chart in Power BI 4

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 5

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.

Create 100% Stacked Bar Chart in Power BI 6

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.

Create 100% Stacked Bar Chart in Power BI 7

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.

Create 100% Stacked Bar Chart in Power BI 8

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

Create 100% Stacked Bar Chart in Power BI 9

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.

Create 100% Stacked Bar Chart in Power BI 10

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).

Create 100% Stacked Bar Chart in Power BI 11