How to Change Axis to Percentage in Tableau

Showing your data as a percentage in Tableau is a simple way to add context and make your charts instantly more understandable. Instead of just displaying raw numbers, percentages help your audience immediately grasp proportions and comparisons. This article will show you exactly how to format your axes to show percentages, covering everything from quick, on-the-fly calculations to creating reusable calculated fields.

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 Does Formatting as a Percentage Matter?

Numbers in isolation can be misleading. If you see that your "Technology" category generated $740,000 in sales, is that good? It's hard to tell without context. But if you see it generated 34% of total sales, you immediately understand its significance relative to other categories. Formatting your axis to a percentage helps you answer vital business questions:

• What percentage of our total website traffic comes from each marketing channel?
• What is each product category's share of total company revenue?
• What is our sales conversion rate month-over-month?

Transforming raw numbers into percentages helps build a clear narrative, making your dashboards more intuitive for everyone, regardless of their data literacy level.

Method 1: The Quickest Way Using a Table Calculation

This is the fastest method for when you need a quick percentage view for a specific chart. It uses Tableau's built-in "Quick Table Calculation" feature. Let’s walk through it with an example of visualizing Sales by Category.

Step 1: Build Your Basic Chart

First, create a simple visualization. For this example, we’ll use the Sample - Superstore dataset that comes with Tableau.

1. Drag the Category dimension to the Columns shelf.
2. Drag the Sales measure to the Rows shelf.

You'll now have a simple bar chart showing the total sales value for Furniture, Office Supplies, and Technology. Notice the Y-axis shows dollar amounts like $200,000, $400,000, etc.

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

Step 2: Apply the "Percent of Total" Calculation

Now, let's change those absolute sales numbers into percentages of the overall total.

1. On the Rows shelf, right-click the SUM(Sales) pill.
2. From the context menu, hover over Quick Table Calculation.
3. Select Percent of Total.

Immediately, two things happen. The bars in your chart will rescale to reflect their percentage of the total, and your Y-axis will change from dollars to decimals (e.g., 0.00, 0.10, 0.20).

This is progress! The data is now in percentage form, but the axis format isn't user-friendly. No one thinks of twenty percent as "0.20" in a business report. Let's fix that.

Step 3: Format the Axis to Show Percentage Symbols

This is the final, crucial step to get the formatting right.

1. In your chart view, move your cursor over the Y-axis (the one showing decimals) and right-click it.
2. Select Format… from the menu.
3. This will open the Format pane on the left side of your workspace. Make sure you are on the Axis tab at the top of this pane.
4. Under the "Scale" section, you'll see a dropdown menu for Numbers. Click it.
5. Choose Percentage.

Voila! Your axis now displays clean, easy-to-read percentage values (0%, 10%, 20%, etc.). You can also use the "Decimal places" setting in this same menu to control the level of precision you want to show.

Method 2: Creating a Reusable Calculated Field

The Quick Table Calculation is great for a one-off chart, but what if you need to use this "Percent of Total Sales" calculation in multiple places? Creating it repeatedly is inefficient. A calculated field is a more robust and reusable solution.

Why Use a Calculated Field?

• Reusability: You can use the same field across multiple worksheets and dashboards without recreating the logic.
• Consistency: Ensures the calculation is always performed the same way.
• Flexibility: You can use calculated fields as components in other, more complex calculations.

Step 1: Create the Calculated Field

1. At the top of the Data pane, click the dropdown arrow and select Create Calculated Field.
2. A dialog box will appear. First, give your calculation a descriptive name. Let's call it % of Total Sales.
3. In the formula box, enter the following expression:

SUM([Sales]) / TOTAL(SUM([Sales]))

Let's briefly break down this formula:

• SUM([Sales]) calculates the sales for the specific dimension in your view (e.g., the sales just for the "Furniture" category).
• TOTAL(SUM([Sales])) calculates the total sales across the entire partition you've defined (by default, the entire table).

By dividing the part (Category Sales) by the whole (Total Sales), you get the percentage. Click OK to save the calculated field.

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

Step 2: Set the Default Number Format (A Great Timesaver)

You can set the default formatting for this new field so that anytime you use it, it will automatically show up as a percentage.

1. Find your new % of Total Sales field in the Data pane (it will be under Measures).
2. Right-click on it.
3. Go to Default Properties → Number Format…
4. In the dialog box, select Percentage from the list. Adjust the decimal places if you wish and click OK.

Step 3: Use the Calculated Field in Your View

Now, you can build (or rebuild) your chart using this new, smarter field.

1. Drag Category to the Columns shelf.
2. Drag your newly created % of Total Sales measure from the Data pane to the Rows shelf.

Because you set the default number format in the previous step, the chart appears with the Y-axis already formatted as a percentage. No extra clicks are needed!

Extra Tips and Common Trouble Spots

Getting your percentage axis is a great start, but here are some common situations you might encounter and how to handle them.

Understanding "Compute Using"

When you use table calculations (both quick ones and those in calculated fields like TOTAL()), you need to tell Tableau how to calculate the "total." This is controlled by the "Compute Using" setting. If you add another dimension, say Region, to your view, your percentages might look wrong.

For example, if you have Region on Rows and Category on Columns, do you want the percent of total for the entire table, the percent of total for just that row (Region), or something else? Adjust this by right-clicking your percentage pill, going to Compute Using, and selecting the appropriate option, e.g., Table (Across), Pane (Down), or a specific dimension.

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

Troubleshooting: My Percentages Are Too High!

If your percentages add up to more than 100% or just seem incorrect, the issue is almost always the "Compute Using" setting. You are likely calculating the percent of total against a smaller chunk ("pane") of your data instead of the whole table. Experiment with different "Compute Using" settings until the result reflects the business logic you need.

Showing Both the Value and the Percentage

A common request is to show the percentage in the main chart but display the raw dollar value in the tooltip when a user hovers over a bar. This provides the best of both worlds: a clean visual with details-on-demand.

1. Build your chart using your % of Total Sales measure on the Rows shelf.
2. Now, drag the original Sales measure directly onto the Tooltip Mark on the Marks Card.
3. Click the Tooltip Mark to edit the text. You can customize it to look something like this: Category: <,Category>, % of Total Sales: <,AGG(% of Total Sales)>, Total Sales: $<,SUM(Sales)>,
4. Now when you hover over a bar, you'll see the context-rich percentage and the hard number that fuels it.

Final Thoughts

Adjusting an axis to display percentages is a fundamental formatting skill in Tableau. Whether you use a quick table calculation for a fast analysis or a robust calculated field for reusable reports, the key is always in the Format → Axis → Numbers menu. Mastering this simple process will make your visualizations clearer and far more insightful for your audience.

Creating these kinds of charts and reports in a visualization tool can be a very hands-on process that requires a lot of clicks and an understanding of underlying concepts like table calculations. With newer AI-native tools, this entire workflow is streamlined. At Graphed, for instance, we've designed our platform so you can simply ask for what you want in plain English. "Show me the percentage of sales by category as a bar chart," and the final, properly formatted chart is generated for you instantly. All the manual steps of creating calculations and formatting axes disappear, letting you move straight from question to insight much faster. If you're interested in speeding up your reporting workflow, you might enjoy giving Graphed a try.