How to Change Number to Currency in Power BI

Seeing your sales figures appear as plain numbers like 150450.25 instead of $150,450.25 can make your Power BI reports feel unpolished and hard to read. Correctly formatting numbers as currency is a small step that makes a huge difference in clarity and professionalism. This article will walk you through several ways to change numbers to a currency format in Power BI, from the simple one-click method to more advanced formatting using DAX.

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 Currency Formatting Matter?

Before jumping into the "how," let's quickly touch on the "why." You're building a report to communicate information quickly and effectively. When your audience sees a number, they have to momentarily pause and process what it represents. Is it a quantity? An ID number? A score?

Applying currency formatting immediately answers that question. It provides critical context without the user needing to think about it. Here’s what it accomplishes:

• Clarity: A dollar sign ($), euro symbol (€), or pound sign (£) instantly tells the user they are looking at a monetary value.
• Readability: Commas as thousand separators (1,000,000 vs. 1000000) make large numbers much easier to read and interpret at a glance.
• Professionalism: Properly formatted reports look more credible and well-thought-out, enhancing the trust your stakeholders have in your data.

Simply put, it’s about reducing cognitive load for your audience, allowing them to focus on the insights, not on deciphering the numbers.

Method 1: The Quickest Fix using the Ribbon Menu

For most day-to-day needs, this is the fastest and most straightforward way to apply currency formatting. Power BI's interface makes this incredibly easy.

Here’s how to do it in Report View or Data View:

Step-by-Step Instructions:

1. Select Your Data Field: In the Fields pane on the right-hand side of your screen, find the data table that contains your numerical value. Click on the specific column or measure you want to format (e.g., 'Sales Amount', 'Revenue', or 'Profit').
2. Open the Tool Tab: Once you select the field, a contextual tab will appear in the main ribbon at the top of the Power BI window. If you selected a column, it will be called Column tools. If you selected a measure, it will be called Measure tools.
3. Apply the Currency Format: In the "Formatting" section of this ribbon, you'll see a drop-down menu that likely says "General." Click on the dollar sign ($) icon. This is a shortcut that will apply the default currency format based on your Windows regional settings.

Alternatively, you can click the drop-down arrow next to the dollar sign to select from a list of major currencies, such as $, £, €, and ¥.

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

Customizing the Default Format:

Once you’ve applied a generic currency format, you can easily tweak it. With the same column or measure selected:

• In the "Formatting" section of the Column tools / Measure tools tab, find the field showing the number of decimal places. You can type in a new number (e.g., 0 for whole dollars or 2 for dollars and cents).
• Use the main format dropdown (that might now say "Currency") to select other specific currency types if needed, like "$ English (United States)" or "€ Euro (€ French (France))".

This method is perfect for 90% of situations and takes just a few seconds.

Method 2: Formatting in the Model View

The Model View in Power BI is where you manage relationships between your data tables. It also provides a powerful interface for formatting multiple columns at once without clicking through them one-by-one in the Fields pane.

Use this method if you’re setting up a new dataset and want to format several monetary fields across different tables in a logical way.

Step-by-Step Instructions:

1. Switch to Model View: In the left-hand navigation bar, click on the icon for the Model View. It looks like three connected boxes.
2. Select Your Column(s): Find the table containing the column you want to format. You can hold down the Ctrl key to select multiple columns at once, even across different tables.
3. Use the Properties Pane: With your column(s) selected, look at the Properties pane (usually on the right side). If it's not visible, go to the "View" tab in the main ribbon and check the box for "Properties."
4. Change the Format: Scroll down in the Properties pane to the "Formatting" section.

• Click the Format drop-down and choose Currency.
• A new option, Currency format, will appear. Here you can choose your specific currency symbol and style.
• You can also adjust the Decimal places in the field below.

The advantage of this view is its efficiency. You can format five different revenue and cost columns from three different tables all at once without leaving the screen.

Method 3: Taking Control with DAX Functions

What if you need more control? Maybe you want to display a value differently based on a condition, or you want to combine the currency symbol with text. For this, you need DAX (Data Analysis Expressions), Power BI's formula language. The primary tool here is the FORMAT function.

Using the FORMAT Function

The FORMAT function converts a value into a text string according to a specific format you define. You would typically use this when creating a new measure.

Let's say you have a measure Total Sales = SUM(Sales[Revenue]). To create a formatted version, you would create a new measure with the following DAX:

Formatted Total Sales = FORMAT([Total Sales], "Currency")

The "Currency" argument tells DAX to use the default system currency format. But the real power comes from using custom format strings:

• FORMAT([Total Sales], "$#,##0.00") - Displays a dollar sign, thousand separators, and two decimal places (e.g., $1,234.50).
• FORMAT([Total Sales], "$#,##0") - Displays the same, but rounded to the nearest whole number (e.g., $1,235).
• FORMAT([Total Sales], "€#,##0.00") - Explicitly uses a Euro symbol for formatting.

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 Critical Warning About the DAX FORMAT Function

This is extremely important for anyone new to DAX. When you use FORMAT, the output is always a text string, even if it looks like a number.

What does this mean?

You cannot perform any mathematical operations on the result. If you try to sum a column of values that were created with the FORMAT function, it won't work. The value for Power BI is text, just like the word "Hello."

Rule of Thumb: Always perform your calculations with raw, unformatted numeric measures first. Only use the FORMAT function on the final measure that you intend to display directly in a visual (like a card, table, or matrix). Do not use formatted measures as building blocks for other calculations.

Method 4: Dynamic Currency Formatting with a Slicer (Advanced)

For reports that serve an international audience, you may need to display values in different currencies based on user selection. You can build a dynamic currency converter directly within your report.

This is an advanced technique, but it showcases the incredible power of DAX.

Concept Overview:

The goal is to let a user click a slicer for "USD," "EUR," or "GBP," and have all the financials in the report update to reflect that currency, including the symbol and a converted value.

To do this, you’ll need:

1. Your base measure in a fixed currency (e.g., [Total Sales USD]).
2. A separate, disconnected table containing currency information (Symbol, Exchange Rate, Format String).
3. A slicer based on this new table.
4. A new "display" measure that checks the slicer's selection and applies the correct conversion and formatting.

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

Example Implementation:

1. Create a Currency Table: In Power Query or using "Enter Data," create a simple table named Currency Selection like this:

2. Create Your Base Measure: Total Sales USD = SUM('Sales'[Revenue])

3. Create the Main "Display" Measure: This DAX measure combines everything. It detects the selected currency, applies the exchange rate, and then formats it correctly.

Dynamic Sales Display = VAR SelectedExchangeRate = SELECTEDVALUE('Currency Selection'[ExchangeRate], 1) VAR SelectedFormatString = SELECTEDVALUE('Currency Selection'[FormatString], "$#,##0.00") VAR ConvertedSales = [Total Sales USD] * SelectedExchangeRate RETURN FORMAT(ConvertedSales, SelectedFormatString)

Now, add a slicer to your report using the 'Currency' column from your Currency Selection table, and display the [Dynamic Sales Display] measure in your visuals. When you select a currency, everything updates automatically!

Troubleshooting Common Formatting Issues

Sometimes things don't go as planned. Here are a couple of common hurdles:

• The Currency Option is Grayed Out: This almost always means your column's data type is not a number. In the Power Query Editor or the Data View in Power BI, check the Data type for your column. If it's Text, change it to Decimal Number or Fixed decimal number. The formatting options will then become available.
• Currency Symbols Don't Appear in a Table: If you've formatted a measure but it still doesn't show the symbol in a specific table or matrix visual, check the visual's own formatting settings. Select the visual, go to the Format visual pane, find the "Specific column" section, and ensure the Values formatting for that field hasn't been set to display units like "Thousands" or "Millions", as this can sometimes override the base format.

Final Thoughts

Formatting numbers correctly in your Power BI reports is a fundamental skill that elevates your work from being a simple data dump to a clear, professional analysis. Whether you use the lightning-fast ribbon menu for everyday tasks or the powerful FORMAT function in DAX for custom and dynamic visuals, understanding these methods gives you complete control over your report's presentation.

While mastering Power BI's formatting rules and DAX syntax is valuable, we know it can also feel like another tedious set of steps between getting your data and sharing your insights. At Graphed, we remove that friction by letting you create dashboards and get analysis just by asking questions. Instead of clicking through menus or writing formulas, you can simply ask, "show me my monthly sales last quarter in EUR," and our AI data analyst builds the visualization for you on a live, interactive dashboard, handling all the connections and formatting automatically.