Tableau is one of the most popular data visualization tools used by professionals worldwide. It helps convert raw data into meaningful insights through charts, graphs, and dashboards.
One of the most commonly used visualizations in Tableau is the pie chart. A pie chart is very useful for showing proportions or percentages of data in a simple, easy-to-understand way.
Many beginners struggle to display percentages in a Tableau pie chart. By default, Tableau may show numbers instead of percentages, which can make the chart less clear for users.
Recently, I created a Pie chart using Tableau to show sales by product category for a monthly review. The pie chart displayed slices in different colors, each representing a subcategory’s sales.
To show the share of Sales for each sub-category in the overall sales, I decided to display Sales percentages instead of sales figures. For this, I need to change the text label format and update the calculation.
In this article, we will learn, step by step, how to display percentages in a Tableau pie chart. We will also cover real-world use cases, common mistakes, and tips to improve your dashboard.
What is a Pie Chart in Tableau?
A pie chart is a circular chart that is divided into slices. Each slice represents a portion of the total value. Pie charts are mainly used to show percentage distribution.
For example:
- Sales by region
- Profit by category
- Customer distribution
Pie charts are useful when:
- You want to compare parts of a whole
- You have limited categories (3–6 is best)
However, pie charts should not be overused because too many slices can make them confusing.
Why Display Percentage in Pie Chart?
In a Tableau Pie chart, percentages show the proportion of a specific category relative to the total across all categories. Instead of showing numbers like sales, percentages show each slice as a share of the total, making it easy to understand relative sizes.
Displaying percentages is very important because:
- It makes data easy to understand
- Users can quickly see proportions
- It improves dashboard readability
- Helps in decision-making
For example, if total sales are $100,000 and the Furniture category accounts for $38,000, its percentage share would be 38%. Seeing 38% instead of 38,000 shows that Furniture accounts for more than one-third of total sales.
Display Percentage in Tableau Pie Chart
To display the percentage of a measure, such as sales and profit, we will first create a Pie chart using Tableau’s Superstore dataset.
Connect the dataset with Tableau and follow the steps below:
Create the Pie Chart
If you have not already created the Tableau Pie chart, do so first by following the steps below.
In this pie chart, I will show the share