Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Add Currency in Power BI

Cody Schneider••7 min read

Displaying numbers as currency is one of the quickest ways to make your Power BI reports clearer and more professional. Instead of leaving users to guess if they're looking at revenue, costs, or simply quantities, a currency symbol provides immediate context. This guide will walk you through the various ways to add currency formatting in Power BI, from the most straightforward click-and-go methods to a more flexible approach using DAX.

GraphedGraphed

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.

Watch Graphed demo video

Why Proper Currency Formatting Matters

Before jumping into the "how," it's worth taking a second to understand the "why." Clean, correct formatting is about more than just aesthetics, it's about efficient communication.

  • Clarity: A dollar sign ($), euro symbol (€), or pound sign (£) instantly tells your audience they're looking at monetary values. This removes ambiguity and makes your charts and tables easier to understand at a glance.
  • Professionalism: Well-formatted reports look more polished and trustworthy. Taking the time to add proper currency formats shows attention to detail and builds confidence in your data.
  • Context: Large numbers like 2500000 are hard to read. Formatting it as $2,500,000.00 with commas and decimal points provides crucial context and improves readability, preventing misinterpretation of your key financial metrics.

In short, it’s a small step that has a significant impact on the usability and effectiveness of your dashboards.

Method 1: The Easiest Way in the Report View

The Report View is where you build your visuals, and it's the most common place to apply formatting. This method is perfect for quick, on-the-fly updates as you are designing your dashboard.

Follow these simple steps:

  1. Select Your Visual: First, click on the chart or table in your report that contains the numeric data you want to format.
  2. Find Your Data Field: In the Visualizations pane on the right, find the specific field that you've dragged into the visual (e.g., in the "Y-axis" or "Values" bucket). Common names for these fields are things like "Sales" or "Revenue." Click on that field.
  3. Use the "Column tools" Ribbon: A new contextual tab called "Column tools" will appear at the top of the Power BI window. This is where the magic happens.
  4. Apply Currency Format: Within the "Column tools" ribbon, you'll see a formatting section. Simply click the dropdown menu next to the currency symbol (which often defaults to a dollar sign).

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.

Choosing Your Specific Currency

What if your business doesn't use the default currency? No problem. In that same "Column tools" formatting section:

  • Click the dropdown arrow next to the dollar sign icon.
  • A list of common currencies will appear, such as $, £, €, and ¥.
  • If your desired currency isn't there, click "More symbols...". This will open up a comprehensive list and you can find the symbol that you're looking for.
  • You can also adjust the number of decimal places in the box right next to the currency format. For whole numbers, you can change this to 0.

The great thing about this method is that any changes you make will instantly be reflected in the visual you've selected.

Method 2: Formatting in the Data View

The Data View gives you a spreadsheet-like look at your data tables. Formatting your columns here is a best practice because it applies the currency format to the column itself, ensuring consistency every time you use that column in any visual.

  1. Navigate to the Data View by clicking the table icon on the far left-hand panel of Power BI.
  2. In the Data pane on the right side of the screen, select the table and the specific column you want to format (e.g., "ProductPrice").
  3. Just like in the Report View, the "Column tools" contextual ribbon will appear at the top.
  4. Click on the currency format dropdown in the "Formatting" group and select your desired currency symbol.

Now, whenever you drag this field into a new table, chart, or card visual, it will automatically have the correct currency formatting applied. This saves you from having to format it over and over again for each individual visual you create.

Method 3: Centralized Formatting in the Model View

The Model View is where you manage relationships between your data tables. It's an excellent place to handle formatting for multiple columns at once, especially in a complex data model, helping you keep things organized.

  1. Switch to the Model View by clicking the relationship icon in the left-hand panel.
  2. Find the table containing your numeric columns. You don't need to select a visual here, just work directly with the data model.
  3. In the Properties pane on the right, find the column you wish to change. Or, even easier, you can select multiple columns at once by holding down Ctrl while clicking on them directly in the table card (e.g., select 'Cost', 'Price', and 'Revenue' all at once).
  4. In the Properties pane, scroll down to the "Formatting" section.
  5. Click the "Format" dropdown, select "Currency", and then choose your exact currency symbol from the dropdown below it. You can also define the decimal places here.

This method is fantastically efficient because you can format several columns across different tables without having to click on each one individually. It reinforces good data modeling habits by making sure formatting decisions are made centrally.

GraphedGraphed

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.

Watch Graphed demo video

Taking Control with DAX Formatting

Sometimes, the built-in formatting options aren't quite enough. You might need to add a currency symbol based on a certain condition (e.g., show USD for United States sales and EUR for European sales in the same column) or create a custom format. This is where DAX (Data Analysis Expressions) comes in.

The primary function you'll use is FORMAT.

Here's how to create a new column with custom currency formatting:

  • Scenario: You have a "Total Sales" column, and you want to create a new text column that displays the sales in a consistent USD format with commas.
  1. While in the Data View, select the table you want to add the column to.
  2. From the Table tools ribbon at the top, click "New column".
  3. The formula bar will appear. Enter a DAX formula like this:

Formatted Revenue = FORMAT('Sales'[Total Sales], "$#,##0.00")

Breaking Down the DAX Formula:

  • Formatted Revenue = This is the name of your new column.
  • FORMAT(...) This is the DAX function you're using.
  • 'Sales'[Total Sales] This is the existing column containing the numeric value you want to format.
  • "$#,##0.00" This is the format string. It's the most important part:

After you press Enter, a new column called "Formatted Revenue" will appear, with all the values displayed as text with your specified currency format. It's important to remember that using FORMAT converts your number into a text value, which means you can no longer use it in calculations. Use the original numeric column for math and this new formatted column for display purposes, like in tables and matrices.

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.

Final Thoughts

And there you have it. Properly formatting numbers as currency is a fundamental skill that elevates your Power BI reports from simple data dumps to clear, professional business tools. We've covered the quick UI methods in the Report, Data, and Model views, as well as the more powerful and flexible DAX FORMAT function for custom needs.

While mastering formatting is essential for building effective reports yourself, we know that the time spent clicking through menus and tweaking visuals can quickly add up. At Graphed, we help you skip the manual work and get straight to the insights. By connecting your marketing and sales data sources, you can ask questions like "show me our revenue by campaign for last month" and instantly get back a finished chart, all built in seconds. Instead of wrestling with formatting details, your time is better spent understanding what the numbers in your report actually mean for your business. You can try Graphed for free and spend less time building and more time analyzing.

Related Articles