How to Change Number to Percentage in Tableau

Transforming raw numbers into percentages inside Tableau is one of the quickest ways to add valuable context to your data. A number like "1,250 sales" is a good start, but knowing that number represents "83% of our quarterly goal" tells a much more useful story for decision-making. This article will walk you through a few different ways to change numbers to percentages in Tableau, from simple formatting fixes to more powerful calculations.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Bother with Percentages?

Dashboards are all about providing insights at a glance. While absolute numbers (like total revenue or number of site visitors) are foundational, percentages help us understand proportion, progress, and performance in a standardized way.

Consider these comparisons:

• Raw Number: "We got 4,500 new leads this month."
• Percentage Context: "We got 4,500 new leads this month, a 15% increase over last month."

Or:

• Raw Number: "The 'Gadgets' category generated $210,000 in revenue."
• Percentage Context: "The 'Gadgets' category generated $210,000 in revenue, accounting for 40% of our total revenue."

The percentage immediately answers the "so what?" question. It allows you to benchmark performance against goals, previous periods, or other segments without needing to do mental math. Now, let's look at how to create these in Tableau.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Method 1: Quick Formatting Fix

This is the most straightforward method and works perfectly when your data is already in a decimal format representing a proportion (e.g., 0.75, which you want to display as 75%). This often applies to rates or ratios that have been pre-calculated in your data source.

Let’s say you have a field called Conversion Rate that is stored as 0.05. Here’s how to display it as 5%.

1. Drag the measure (e.g., Conversion Rate) you want to format into your view, perhaps onto the Text mark on the Marks card.
2. In the view, right-click the number or on the measure's “pill” in the Rows, Columns, or Marks shelf.
3. From the context menu, select Format....
4. The Format pane will open on the left-hand side of your screen. Under the Default section, click the Numbers dropdown.
5. Choose Percentage from the list.
6. You can then specify the number of decimal places you want to show. For most dashboard use, 0 or 1 decimal place is cleanest and easiest to read.

That's it. Tableau will now correctly display that decimal value as a formatted percentage, adding the "%" sign for you.

Method 2: Using a Calculated Field

Often, your raw data sources won’t have the percentage pre-calculated. Instead, you'll have the two components needed to create it - for example, Actual Sales and Sales Goal, or Clicks and Impressions. In this situation, you need to first tell Tableau how to calculate the percentage with a calculated field, and then format it.

Example: Calculating Sales vs. Goal

Imagine you want to see what percentage of your sales goal has been achieved. You have one field for total sales and another for the goal.

1. In the Data pane on the left, right-click anywhere in the empty space and select Create Calculated Field....
2. A new window will open. First, give your calculation a descriptive name, like "Percent of Sales Goal."
3. In the formula box, you'll write the division equation. It's best practice to wrap your measures in an aggregation like SUM(). Your formula would look like this:
4. Click OK. You'll now see your new [Percent of Sales Goal] field in the Data pane under Measures.
5. Drag this new calculated field into your view.
6. At this point, you'll see a decimal number. Now, simply follow all the steps from Method 1 to format this new field as a percentage.

Creating a calculated field is a two-step process: first, you define the calculation, and second, you format the result. This approach gives you full control over exactly what your percentage represents.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Advanced Shortcut: Using Quick Table Calculations

Tableau includes a fantastic shortcut for some of the most common percentage-based analyses you'll ever need to do, like finding the percent of total or the percent difference over time. These are called Quick Table Calculations, and they save you from having to write formulas manually.

Calculating Percent of Total

Let's say you have a bar chart showing Sales by Product Category and you want to know what percentage of the total sales each category contributes.

1. Build your initial view. Drag Category to Columns and SUM(Sales) to Rows to create your bar chart.
2. Right-click the SUM(Sales) pill on the Rows shelf.
3. In the menu that appears, hover over Quick Table Calculation.
4. From the sub-menu, select Percent of Total.

Tableau instantly changes the axis and the bar heights to represent the percent of total instead of the raw sales values. You can add the percentages as labels by dragging the same SUM(Sales) pill with the table calculation onto the Label mark.

Calculating Percent Difference (e.g., Month-over-Month Growth)

Another common need is seeing how a metric has changed over time. Let's calculate the month-over-month growth of website traffic.

1. Create a line chart with a time dimension. Drag MONTH(Date) to Columns and SUM(Sessions) to Rows. Make sure your Date field is set to a discrete month (the blue pill).
2. Right-click the SUM(Sessions) pill on the Rows shelf.
3. Hover over Quick Table Calculation and select Percent Difference.

Your line chart will now show the percentage growth or decline in sessions from one month to the next. The first month will be blank because there is no prior period to compare it to. This is a powerful, two-click way to start analyzing trends and performance momentum.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Tips for Better Percentage Visualizations

Just showing the percentage is only half the battle. How you display it can make it much more effective.

• Keep It Clean: Avoid showing too many decimal places. For a high-level dashboard, 23% is almost always better and faster to read than 23.47%. Be concise.
• Use Color Strategically: You can create a simple calculated field like [MoM Growth] > 0 and drag it to the Color mark. This will automatically color positive growth green and negative growth red, giving viewers an instant visual cue.
• Provide Clear Labels: The number 45% is meaningless without context. Ensure your chart title, axis, or tooltip clearly states what it's a percentage of. Is it "% of Total Revenue," "% of Goal," or "% Growth vs. Prior Year"?

Final Thoughts

As we've seen, changing a number to a percentage in Tableau can range from a simple format change to creating a new calculated field or using a Quick Table Calculation for more advanced analysis. Mastering these methods will significantly improve the clarity and impact of your dashboards, helping your audience move from seeing data to understanding what it means.

While learning these capabilities in Tableau provides a great deal of control, the process of finding the right menu, remembering formula syntax, and managing formatting can still be time-consuming. We built Graphed to eliminate that friction entirely. Instead of clicking through menus to create a percent of total calculation, you can simply ask, "Show me product sales as a percentage of total," and get an interactive chart in seconds. We believe that getting answers from your data should be as easy as asking a question, empowering anyone on your team to find insights without needing to become a BI software expert.