How to Change Currency in Tableau

Displaying sales, revenue, or budget data in your Tableau dashboard requires getting the currency format right, but this is often easier said than done. Your numbers can come from different regions or data sources, making a single, static format insufficient. This guide walks you through several methods for changing and managing currencies in Tableau, from simple formatting fixes to dynamic calculations that give your users full control.

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 Fix: Setting a Default Currency Format

If all the financial data in your entire data source uses a single currency, your task is incredibly simple. You can set a default format for any measure, and Tableau will apply it every time you use that field in a new visualization.

Let's say you have a measure called "Revenue" and you want to ensure it always shows up with a US dollar sign ($) and two decimal places.

Here’s how you do it:

1. Find your measure (e.g., "Revenue") in the Data pane on the left side of your screen.
2. Right-click on the measure and hover over Default Properties.
3. Select Number Format... from the context menu.

This opens a dialog box where you can specify the exact formatting you need. For currencies, you'll have a few options:

• Currency (Standard): This automatically formats the number based on your computer's locale settings. It's quick, but it might not be the specific currency you want to display for your audience.
• Currency (Custom): This gives you full control. You can specify the number of decimal places, the negative value format, units, and most importantly, the prefix/suffix. Here, you can type the "$" symbol directly as a prefix.

For more specific symbols like the Euro (€) or British Pound (£), select Currency (Standard) and use the Locale dropdown menu to find the appropriate country. Selecting "English (United Kingdom)," for example, will automatically apply the pound sterling (£) symbol.

Once you set this default property, every time you drag "Revenue" into a new view, it will already be formatted correctly. This is a massive time-saver for keeping your reports consistent.

Best for: Dashboards where all your data shares a single, common currency.

Handling Multiple Currencies in Your Data

The real world of data is messy. Oftentimes, a single column of sales data will contain values from different parts of the world, representing transactions in USD, EUR, and GBP. In this case, applying a single default format like "$" to all of them is misleading and incorrect.

To solve this, you need to use a calculated field that dynamically applies the correct symbol based on a currency dimension in your data.

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 1: Ensure Your Data is Structured Properly

This method requires your data source to have at least two fields:

• A numerical field for the transaction amount (e.g., Sales Amount).
• A dimension field that identifies the currency for each row (e.g., Currency Code with values like 'USD', 'EUR', 'GBP').

Without the Currency Code field, Tableau has no way of knowing which symbol to apply to which number. If your data isn't structured this way, you'll need to clean it up in your source system, SQL query, or a data prep tool before bringing it into Tableau.

Step 2: Create a Calculated Field for Currency Symbols (Prefixes)

Next, you’ll create a calculated field that translates the currency codes into their respective symbols.

1. Right-click anywhere in the Data pane and select Create Calculated Field.
2. Name your new field something clear, like Currency Symbol.
3. Enter the following formula using a CASE statement:

CASE [Currency Code]
WHEN 'USD' THEN '$'
WHEN 'GBP' THEN '£'
WHEN 'EUR' THEN '€'
WHEN 'JPY' THEN '¥'
ELSE ''
END

This formula tells Tableau to look at the Currency Code for each row. If it finds 'USD', it returns a '$' symbol, if it finds 'GBP', it returns a '£' symbol, and so on. The ELSE '' part handles any unexpected codes by returning a blank, so your visualization doesn’t break.

Step 3: Combine the Symbol and the Amount for Display

You have two choices for displaying your newly created symbol alongside the sales amount. Each has important trade-offs.

Method A: Creating a Combined String Label (for Text Tables)

You can create another calculated field that combines the symbol and the formatted value into a single text label. Name this field Display Sales.

[Currency Symbol] + STR(ROUND([Sales Amount], 2))

Here’s the breakdown:

• ROUND([Sales Amount], 2) rounds the sales number to two decimal places.
• STR(...) converts the rounded number into a string (text).
• [Currency Symbol] + ... prepends the correct symbol from our previous calculation.

You can drag this Display Sales field onto Text or Label on the Marks card. It works perfectly for text tables.

Warning: This method converts your number into text. That means you can no longer use it in charts as a measure (e.g., as the length of a bar or a point on a line graph), and you can't perform mathematical aggregations like SUM() or AVG() on it. This approach should only be used for display labels.

Method B: Keeping the Fields Separate (for Charts and Visualizations)

A better and more flexible approach is to keep the number as a number and use the symbol separately.

1. Drag your numeric field (Sales Amount) to the Columns shelf and your grouping dimension (e.g., Country) to the Rows shelf.
2. To show the symbol, simply drag the Currency Symbol calculated field onto the Label or Tooltip on the Marks card. For tables, you drag it onto the Rows shelf right beside your Country dimension.

This way, you can create a bar chart showing sales by country, and the symbol appears next to the number in the header while keeping the field as a proper measure. You get the best of both worlds: correct labels and a functional numeric axis.

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

Using a Parameter for Dynamic Currency Conversion

What if you want to give your dashboard users the ability to see all sales data converted to a single currency of their choice? For example, allow them to view the entire report in either USD, EUR, or GBP. This is completely achievable with parameters.

Step 1: Set Up Exchange Rates in Your Data

This advanced method relies on having exchange rates available in your data. Ideally, you’d have a field that can convert any local currency into a single base currency, such as USD. For example, your data might include a column like Rate_to_USD.

Step 2: Create a Parameter for Currency Selection

A parameter is a user-controlled input. In this case, we'll create a dropdown menu so the user can pick a currency.

1. Right-click in the Data pane and select Create Parameter.
2. Name it Select Display Currency.
3. Set Data type to String.
4. Under Allowable values, choose List.
5. Add the currency codes you want to support (e.g., 'USD', 'EUR', 'GBP') to the list.
6. Click OK. Then, right-click the parameter and select Show Parameter to make it appear in your view.

Step 3: Create a Calculated Field for Converted Revenue

Now, we create a calculated field that uses the parameter selection to convert the sales amount. For this example, let's assume you've already created a Sales in USD field by multiplying your local sales amount by the Rate_to_USD. This calculated field, named Converted Sales, will perform the next step:

CASE [Select Display Currency]
WHEN 'USD' THEN [Sales in USD] * 1.00
WHEN 'EUR' THEN [Sales in USD] * 0.92  // Example Rate: 1 USD = 0.92 EUR
WHEN 'GBP' THEN [Sales in USD] * 0.79  // Example Rate: 1 USD = 0.79 GBP
ELSE [Sales in USD]
END

Note: In a real-world scenario, you wouldn't want to hard-code exchange rates into a calculation. The best practice is to load a daily exchange rate table as a separate data source and use data blending or relationships to join it with your sales data.

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 4: Use the New Field and Format It

Drag this new Converted Sales measure into your view instead of the original sales field. As the user selects a currency from the parameter dropdown, all the numbers on the screen will update automatically.

To finish the professional touch, you can even make the currency symbol update dynamically, too. Just create one final calculated field for the display symbol (like we did in the previous section, but based on the parameter) and place that field in your chart titles or tooltips.

Final Thoughts

Handling currencies in Tableau can be as simple as changing a number format or as complex as building a user-controlled conversion dashboard. The key takeaway is that the right approach depends entirely on how your source data is structured and whether you need to manage one currency or many. For simple cases, a default format is perfect, but for multi-currency reporting, calculated fields and parameters are your best friends.

Manually tracking down currency data, managing exchange rates, and combining scattered reports often turns into a major time sink that pulls you away from actual analysis. At Graphed , we automate the hard parts. You can effortlessly connect sources like Shopify, Salesforce, and Google Analytics in minutes. Instead of building complex calculations, you can just ask questions in plain English like, "create a dashboard showing my Shopify sales in EUR compared to Facebook Ads spend" and get a live, interactive visualization instantly. That way, you're free to focus on finding insights, not wrestling with currency formats.