Create a 100% Stacked Bar Chart in Tableau

At our company, we reviewed sales reports using Tableau stacked bar charts. This chart shows us the total sales for each category, but bigger categories like Technology always take up most of the space. As a result, it becomes difficult to see how smaller categories or their subcategories are performing.

Along with the total sales numbers, the management also wanted to know the percentage share of each sub-category within its category. For example, instead of just knowing that Chairs made $50,000 in sales, they wanted to see that Chairs contributed 60% of the total Furniture sales.

As a solution for this, we used a 100% stacked bar chart in Tableau. This chart displays every bar at 100%, and the segments within the bar represent the percentage share of each sub-category.

In this Tableau tutorial, I will explain how to create a 100% stacked bar chart in Tableau.

Tableau 100% Stacked Bar Chart

In Tableau, a 100% stacked bar chart is a type of bar chart where each bar represents 100% of a category’s total. The segments or stacks within the bar indicate the percentage contribution of each part to the total. Unlike a standard stacked bar chart that displays actual values, a 100% stacked bar chart focuses on relative shares or proportions.

Create 100% Stacked Bar Chart in Tableau

To create a 100% stacked bar chart in Tableau, we will use the Tableau Superstore dataset. In this stacked bar chart, we will show the sales of categories across regions.

To create a 100% stacked bar chart in Tableau, there are two methods that we will discuss in the points below.

  • Create 100% Stacked bar chart in Tableau using Table Calculation
  • Create 100% Stacked bar chart in Tableau using dual axis

Create 100% Stacked Bar Chart in Tableau Using Table Calculation

Now, connect the tableau to the data source and follow the steps below to create a 100% stacked bar chart in Tableau using table calculation.

  1. For the stacked bar chart, add ‘Sales‘ to Rows, ‘Regions‘ to Columns, and ‘Category‘ to Color card in the Marks section.
100% stacked bar chart in Tableau

This will stack the sales of the category for regions in each bar.

  1. For the measure value, add the Sales(SUM) to the Label card in the Marks.
Create a Stacked Bar Chart with 100%
  1. For 100% stacked bar chart, we need to convert the number into a percentage. For this, click on the Sales label in the Marks and select Format.
Create a 100% stacked bar chart in tableau
  1. In the Format select Pane -> Default -> Numbers -> Percentage. We can also remove the decimals from the