How to Add Dollar Sign in Tableau

Adding a dollar sign to your numbers is one of the most common formatting tasks in Tableau, yet it can be surprisingly tricky if you don't know where to look. Getting your sales figures, revenue projections, and marketing spend to display as actual currency makes your dashboards clearer and more professional. This guide will walk you through several easy methods for adding a dollar sign in Tableau, from the quickest click to more advanced custom formats.

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

The Easiest Way: Set the Default Currency Format

If you have a measure in your data source that will always represent a currency (like "Sales," "Revenue," or "Ad Spend"), the most efficient approach is to set its default formatting. This tells Tableau to automatically apply the dollar sign everywhere you use that measure, saving you from formatting it over and over again on different charts and dashboards.

Think of it as setting a "format once, use everywhere" rule.

Step-by-Step Instructions:

1. Find the measure you want to format in the Data pane on the left side of your screen. This will be under the "Tables" section.
2. Right-click on the measure's name (for example, right-click on "Sales").
3. From the context menu, navigate to Default Properties > Number Format.
4. A dialog box will pop up. In this window, select Currency (Standard) or Currency (Custom) from the list.

Currency (Standard) is usually all you need. It automatically formats the number based on your computer's locale settings, adding a dollar sign and two decimal places (e.g., $1,500.50). This works perfectly for most reporting scenarios.

When to Use Currency (Custom)

If you need more control, select Currency (Custom). This unlocks a few extra options:

• Decimal places: You can change the number of decimal points. For high-level financial reports, you might want zero decimal places to show rounded dollar amounts.
• Negative Values: Choose how to display negative numbers. The default is typically a minus sign (-$100), but you can select parentheses ($100), which is common in accounting.
• Units: This is incredibly useful for large numbers. You can automatically display them in Thousands (K), Millions (M), Billions (B), etc. So, $1,500,000 becomes $1.5M without needing a messy calculation.
• Prefix/Suffix: The prefix is already set to "$" for currency. You could add a suffix if needed, but it's less common for dollar amounts.

Once you click "OK," this measure will now automatically be formatted as currency every time you drag it into a new view. This method is the best practice for any dedicated sales, revenue, or cost fields.

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

How to Format Currency for a Specific Chart or Table

Sometimes, a field doesn't always need to be a currency. For instance, a "Quantity" field might be used for units sold, but when multiplied by price, the result should be currency. In other cases, you might want a field to appear as a standard number in one chart but as a currency in another.

For these situations, you can format the number directly within the worksheet. This formatting only applies to that specific instance of the measure and overrides the default format.

Step-by-Step Instructions:

1. Add a measure to your view by dragging it onto the Rows, Columns, or Marks card (like onto the "Text" or "Tooltip" property).
2. Right-click the green measure "pill" in the view.
3. Select Format from the menu. The Format pane will open on the left side of the screen.
4. Ensure you are on the Pane tab (or Axis tab, if your measure is forming an axis). Under the "Default" header, click the Numbers dropdown.
5. Select Currency (Standard) or Currency (Custom) and adjust the settings just like you did for the default properties.

Your changes will immediately appear on the chart or table you're working on. This direct formatting method gives you the flexibility to display the same data in different ways across your workbook without altering the default behavior of the measure itself.

Using a Calculated Field for Currency Formatting

For ultimate flexibility, you can turn to calculated fields. While this is a more advanced approach, it's the right choice when your formatting depends on other data, like showing multiple international currencies in a single column.

A Very Important Caution: A common mistake is to convert a number to a string to add a dollar sign. For example, creating a calculation like:

"$" + STR([Sales])

While this technically works, it creates a big problem: it converts your number into a text string. When Tableau sees text, it can no longer perform mathematical operations on it. You won't be able to sum it, find its average, sort it numerically (it would sort alphabetically like this: $1, $100, $2), or use it to create numerical charts like bar graphs. Always use Tableau's built-in number formatting options before resorting to a string conversion trick.

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

A Practical Use Case: Handling Multiple Currencies

Let's say your data includes sales from different countries, and you want to display the correct currency symbol for each one.

1. Create a calculated field by clicking the dropdown in the Data pane and selecting "Create Calculated Field."
2. Name the field something like "Formatted Sales."
3. Let's assume you have a field called [Country]. You could use a CASE statement to apply different currency symbols:

CASE [Country]
WHEN "United States" THEN "$ " + STR([Sales])
WHEN "United Kingdom" THEN "£ " + STR([Sales])
WHEN "Japan" THEN "¥ " + STR([Sales])
ELSE "$ " + STR([Sales])
END

Remember, this calculation turns your sales figures into a text string, making it suitable for text tables or labels where you don't need to perform any more calculations on the field. If you needed to still sum or aggregate, you would keep a separate numeric version of the sales field for calculations and use this new string field just for display.

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

Level Up with Custom Formatting Codes

If you find the built-in options aren't quite enough, you can write your own custom number formats. This is the most powerful method and lets you define exactly how your numbers, both positive and negative, should appear.

To access this, go to the Format Numbers dialog (via either the default properties or the in-sheet format option), and select the Custom option at the very bottom of the list.

The format is typically specified in two parts, separated by a semicolon: Positive format,Negative format. Here are some useful custom codes for currency:

• Standard Currency with Two Decimals: Shows a dollar sign, commas for thousands, and two decimal places. Negatives are shown with a minus sign.
• Accounting Style with Parentheses for Negatives:
• No Decimals: Ideal for high-level summary dashboards.
• Abbreviated for Thousands (K): Displays large numbers in a more compact format. The comma at the end tells Tableau to divide by 1,000.
• Abbreviated for Millions (M): Similar to the above, but the two commas signal division by one million.

Custom formatting can seem daunting, but it gives you pixel-perfect control over how numbers appear in your Tableau dashboards without compromising their underlying numeric value.

Troubleshooting Common Dollar Sign Issues

What if you've tried the above and something still looks wrong? Here are a couple of common stumbling blocks and how to fix them.

• "My numbers are sorting alphabetically (e.g., $10, $100, $2, $200)." This almost always means you've converted the number to a text string using a calculation like "$"+STR([Sales]). Go back and remove this calculation. Instead, use the original numeric field and apply currency formatting using one of the methods described above.
• "I created a new calculation and the dollar sign disappeared." Whenever you create a new calculated field, Tableau gives it a default number format. Any formatting from the input fields (like the dollar sign on your "Sales" measure) doesn't carry over. You'll simply need to format the new calculated field itself by right-clicking it and applying the currency format.

Final Thoughts

Adding a dollar sign in Tableau is easy once you know where to find the options. For consistency, set a measure's default properties to currency format. For one-off situations, format the pill directly on your worksheet. And for complex logic like handling multiple currencies, you can use calculated fields - just be mindful of changing the data type.

While mastering these details in Tableau is rewarding, sometimes you just need insights quickly, without diving into formatting panes and writing custom code. We created Graphed because we believe getting answers from your data shouldn't require so much manual work. You can connect your marketing and sales data sources in seconds, then use plain English to ask for the report you need - Graphed builds it for you in real-time, correctly formatted and ready to share, letting you focus on strategy instead of report-building.