- Right-click the measure field, choose 'Quick Table Calculation' from the drop-down menu, then click 'Percent of Total'.
- Open the measure field, then add '*100' to the end of the equation to display the result as 100%
- The chart will now display the data in percentage format.
How to Show Percentage in Tableau
Follow this interactive demo to learn how to show percentage in Tableau.
📌 Why this matters
Percentages transform raw numbers into instantly comparable insights, letting you spot patterns that absolute values often hide. When you're analyzing sales performance across regions or budget allocations across departments, percentages reveal the relative importance of each component at a glance. This becomes especially powerful when your underlying data changes frequently—percentages automatically adjust to show shifting proportions, making your dashboards more dynamic and helping stakeholders quickly grasp what's gaining or losing ground without mental math.
Your product deserves an interactive demo
