How Do I Format a Calculated Field in Tableau?

You’ve written the perfect calculated field in Tableau, but it shows up on your dashboard as a raw number like 0.1574 or 5,765.32. Now you have to figure out how to add a percent sign, a dollar symbol, or just clean it up with some commas. This article will show you exactly how to format your calculated fields so your dashboards are clear, professional, and easy to understand.

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 Formatting Your Calculated Fields is a Big Deal

Proper formatting isn't just about making things look nice, it’s about clarity and accuracy. When you present data, you want your audience to grasp its meaning instantly, without having to stop and interpret raw numbers. Showing a profit ratio as 22.5% is immediately understandable, while its raw form, 0.22548, forces your viewer to do mental math.

Think about it:

• Large numbers: Is 1500000 one hundred fifty thousand or one point five million? Adding a comma, like 1,500,000, removes all doubt.
• Currency: A huge number representing revenue doesn’t have the same impact until it has a currency symbol in front of it, like $1.5M.
• Percentages: Displaying 0.85 when you mean 85% can easily lead to misinterpretation, especially in a fast-paced meeting.

Taking a few seconds to format your calculated fields cleans up your work and ensures your insights are communicated effectively. Luckily, Tableau makes this process straightforward.

Method 1: The Best Practice – Format from the Data Pane

The best way to format a calculated field is by setting its default properties. This means that every time you drag this field into any new worksheet, it will already have the correct formatting applied. You set it once and it’s done.

You’ll do this in the Data Pane on the left side of your Tableau workspace, where all your dimensions and measures are listed.

Here’s the step-by-step process:

1. Find your calculated field in the Data Pane.
2. Right-click on the field name.
3. In the context menu, hover over Default Properties.
4. Select Number Format... (or Date Format... if it's a date field).

This opens a dialog box that gives you complete control over how the numbers in that field are displayed. Let's look at a few common scenarios.

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

Scenario 1: Formatting as Currency

Let's say you've created a simple calculated field called ‘Projected Sales’ by increasing current sales by 10:

[Sales] * 1.10

By default, Tableau will display this as a plain number. To make it show as US Dollars, do the following:

1. Right-click on your ‘Projected Sales’ in the Data Pane.
2. Go to Default Properties > Number Format....
3. In the dialog box, select Currency (Standard) or Currency (Custom) from the list.
4. You can now set the decimal places, choose how to display negative values (e.g., with a minus sign or in parentheses), and confirm the prefix is '$'.

Once you click OK, any time you use ‘Projected Sales’ in a view, it will automatically appear as properly formatted currency, such as $550.00.

Scenario 2: Formatting as a Percentage

Percentages are one of the most common calculated fields. Imagine you created a ‘Profit Ratio’ calculation:

SUM([Profit]) / SUM([Sales])

This formula correctly produces a decimal value like 0.184. To display this as a percentage:

1. Right-click on your ‘Profit Ratio’ in the Data Pane.
2. Go to Default Properties > Number Format....
3. From the format list, select Percentage.
4. Adjust the number of decimal places you want to show (usually 1 or 2 is sufficient).

Tableau will automatically handle the conversion. Your 0.184 will now display cleanly as 18.4% everywhere you use it.

Important Tip: Do not multiply your calculation by 100 (e.g., (SUM([Profit]) / SUM([Sales])) * 100). Let Tableau's percentage formatter do the work. If you multiply by 100 in the formula, Tableau will show it as 1840.0%, which is incorrect.

Scenario 3: Controlling Decimal Places and Adding Commas

Sometimes you just want to clean up a large, messy number. For a calculated field like ‘Average Order Value’, you might not need a currency symbol, but you do want commas and a limit on decimal points.

1. Right-click on the field in the Data Pane.
2. Go to Default Properties > Number Format....
3. Select Number (Custom).
4. Set the number of Decimal places you need (e.g., 2).
5. Make sure the Include thousands separators box is checked.

This will turn an unwieldy 154943.5828 into a much more readable 154,943.58.

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

Scenario 4: Custom Date Formatting

Calculated fields that produce dates also need formatting. What if you create a field for a follow-up date three days after an order [Order Date] + 3? The default might be 1/3/2024, but you’d rather spell it out for clarity.

1. Right-click your calculated date field.
2. Go to Default Properties > Date Format....
3. Here you can choose from a list of standard formats (like March 2001 or 3/14/01) or create your own.
4. Select Custom and type in a format using Tableau's placeholders. For example, to get "Wednesday, January 03, 2024," you would type: dddd, mmmm dd, yyyy.

A few common date codes to know:

• d, dd: Day of the month (5, 05)
• ddd, dddd: Abbreviated and full day of the week (Mon, Monday)
• m, mm: Month of the year using numbers (3, 03)
• mmm, mmmm: Abbreviated and full month name (Mar, March)
• yy, yyyy: Two-digit and four-digit year (21, 2021)

Method 2: Format Directly on a Worksheet

What if you want a calculated field to be formatted differently in separate views? For instance, you might want to show your total sales as $1.5M in a high-level KPI card, but as $1,523,498.72 in a detailed table.

In this case, you don’t want to change the default property. Instead, you can format the field for a specific instance on a single worksheet.

1. Drag your calculated field onto a shelf in your worksheet (e.g., onto Text on the Marks card).
2. Right-click the green “pill” representing your field.
3. Select Format... from the menu.

The Format Pane will open on the left. Under the "Header" or "Pane" tab, you can adjust the number format for only that specific instance of the field. All other uses of the field on different worksheets will retain the default format you set in the Data Pane.

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

Advanced Method: Formatting with Functions inside the Calculation

There are rare situations where standard number formatting isn't enough. What if you want to create a label that combines text and a dynamic number, like "YoY Growth: +5.4%"?

Tableau’s number formatting tools can add a prefix or suffix, but they can't place text in front of an already-positive number (+) or embed a number within a sentence. To do this, you need to convert your number into a string directly inside the calculation itself.

The catch is that once you turn a number into a string (text), you can no longer use it in other mathematical operations or plot it as a continuous measure. This method is only for creating final display labels.

Let's say you have a ‘YoY Growth’ calculated field that produces 0.05. You want to display it as +5.4%.

Here’s how you could modify the calculation for a label:

IF [YoY Growth] > 0 THEN
  "+" + STR(ROUND([YoY Growth] * 100, 1)) + "%"
ELSE
  STR(ROUND([YoY Growth] * 100, 1)) + "%"

Here’s a simpler example for profit labels:

"Profit: " +
IF SUM([Profit]) > 0 THEN
  "$" + STR(ROUND(SUM([Profit]), 2))
ELSE
  "-$" + STR(ROUND(ABS(SUM([Profit])), 2))

This example turns your Profit measure into a string. A positive value like 640 shows up as "Profit: $640", while -640 would appear as "Profit: -$640". The STR() function converts a number to a string, and the ROUND() function lets you control decimals.

Final Thoughts

Getting your numbers to look right in Tableau is a simple skill that elevates the quality and clarity of your entire analysis. For consistent formatting, always set the default properties in the Data Pane. If you need a special one-off format in a chart, format the pill directly on the worksheet. And when you need to embed dynamic numbers in text, using string functions like STR() is the way to go.

Manually connecting all your platforms like Ads manager, Google Analytics, and Shopify - then wrangling their calculated fields and formatting - can be exhausting. With Graphed , we handle the integration and visualization process for you. Simply describe the charts you want in plain English, and Graphed instantly creates solid, reliable dashboards, with all your data presented the way it should be - no manual formatting needed.