Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Add Dollar Sign in Power BI

Cody Schneider••7 min read

Nothing makes a financial report clearer than a simple dollar sign. When you're looking at sales figures, budgets, or revenue, formatting those numbers as currency makes them instantly readable and professional. This article will show you the easiest ways to add a dollar sign ($) in Power BI, from a simple button click in the menu to a custom DAX formula for more control.

GraphedGraphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Watch Graphed demo video

Why Correct Number Formatting is a Big Deal

Before we jump into the "how," let's quickly touch on the "why." Proper formatting isn't just about making your reports look nice, it's about clarity and accuracy. When your team sees $50,000 instead of 50000, there's no room for misinterpretation.

  • Reduces Ambiguity: Is 120 one hundred twenty dollars or one hundred twenty units sold? A $ removes all doubt.
  • Improves Readability: Large numbers like $1,250,755.30 are far easier to read and comprehend with currency symbols and commas than 1250755.3.
  • Looks Professional: Properly formatted reports show attention to detail and make your analysis more credible to stakeholders, managers, and clients.

Taking a few seconds to format your numbers correctly can save minutes of confusion and make your entire dashboard more effective.

The Easiest Method: Using the Modeling Tab

For 95% of situations, this is the quickest and most effective way to add a dollar sign to your data. Power BI has built-in currency formatting tools that are just a few clicks away. This method applies the formatting directly to the column or measure itself, ensuring it stays consistent across all the visuals in your report.

Step 1: Select Your Data Field

First, find the numeric field you want to format. In the Data pane on the right-hand side of your screen, click on the measure (the little calculator icon) or the column (the grid icon) that contains the data you need to format. For example, you might click on a measure named "Total Revenue" or a column called "SalesAmount."

Once you select it, the ribbon at the top of the Power BI window will update to show you context-specific options. You should see a tab called either Measure tools or Column tools appear.

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Step 2: Go to the Formatting Group

With your data field selected, look at the ribbon. In the Measure tools or Column tools tab, you'll see a section called "Formatting." This is your command center for all things related to number formatting.

You'll see a dropdown menu that probably says "General" by default. This is what we need to change.

Step 3: Choose 'Currency' from the Format Dropdown

Click the format dropdown menu. You’ll see a list of options like "Whole number," "Decimal number," "Percentage," and more. Click on Currency. Power BI will immediately reformat your column or measure.

An even faster way is to simply click the dollar sign icon $ directly in the Formatting group. This works as a shortcut to apply the default currency format.

Step 4: Select the Correct Kind of Dollar

Power BI is pretty smart and will often use your computer's local currency settings by default. But sometimes you might get a different symbol, or you might need to specify the currency for a universally understood report. If an unwanted currency symbol appears (like the Euro € or British Pound £), it's an easy fix.

Right next to the format selection, there is another dropdown specifically for the currency symbol. Click on it, and you'll see a long list of world currencies.

Scroll down until you find your desired format, such as $ English (United States). Selecting this will ensure every value in your field is preceded by a dollar sign.

Advanced Formatting: Using DAX Functions

Sometimes the standard formatting options aren't quite enough. Maybe you need to embed the currency values within a text string, or you need highly specific formatting that isn't available in the menu. In these cases, you can turn to Data Analysis Expressions (DAX) and use the FORMAT function.

DAX gives you pixel-perfect control over how your numbers are displayed.

GraphedGraphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Watch Graphed demo video

When to Use the DAX FORMAT Function

You should use FORMAT when you need to:

  • Present a number with custom rules (e.g., displaying thousands as 'K' or millions as 'M').
  • Combine a formatted number with text in a single field (e.g., "Total Sales: $1.2M").
  • Create a dynamic label for a visual.

To do this, you’ll create a new measure or a calculated column.

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

Let's break down this formula:

  • Formatted Revenue: This is the name of our new measure.
  • FORMAT(): This is the DAX function that converts a value to text with a specified format.
  • 'Financials'[Revenue]: This is the original numeric data we want to reformat. It's the source.
  • "$#,##0.00": This is the format string, and it dictates exactly how the output should look.

A Critical Warning: FORMAT Turns Numbers Into Text

This is extremely important to understand. When you use the FORMAT function, your numeric value is converted into a text string. While it might look like a number, Power BI sees it as "text."

This means you cannot perform mathematical operations on a measure or column created with the FORMAT function. You can't sum it, find the average, or use it on a chart axis that requires a numeric value.

Because of this, the best practice is to always keep your original, unformatted numeric measure (e.g., Total Revenue). Use that for all your calculations. Then, create a separate formatted measure (e.g., Formatted Revenue) only for display purposes in places like Card visuals, Tables, or Matrices where the final text output is what matters.

Troubleshooting Common Formatting Issues

Sometimes things don't go as planned. Here are some solutions to common problems you might encounter when formatting currency.

1. "I'm seeing Euros (€) or another currency instead of dollars."

This is the most common issue. Power BI's default behavior is to use the regional settings of your computer or account.

The Fix: No need to panic. Simply follow Step 4 from the Modeling Tab section above. Select the measure or column, go to the Formatting section in the ribbon, and use the currency symbol dropdown to select $ English (United States) or another dollar variant.

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

2. "My formatting doesn't show up in a specific visual."

You've formatted the measure in the Modeling Tab, but your bar chart or table still shows 50000 instead of $50,000.

The Fix: A visual can sometimes have its own format settings that override the default data model formatting. Select the problematic visual, then go to the Format your visual pane (the paintbrush icon). Check the settings for the Y-axis (for charts) or the 'Specific column' section (for tables). Look for a "Display units" setting and make sure it's set to 'Auto' or is configured in a way that respects your chosen currency format. Resetting these to default often resolves the issue.

3. "I used the DAX FORMAT function and now my totals are wrong or blank."

This comes back to the text conversion issue. The "Total" row in a table or matrix tries to sum all the values in that column. Since your FORMAT measure is made of text strings, it can't be summed.

The Fix: Use the right tool for the job. Use your original, unformatted numerical measure in visuals that need to calculate totals or display data over an axis. Only use your DAX-formatted text measure in visuals that are meant to display a single, final value, like a Card component.

Final Thoughts

Adding a dollar sign in Power BI is a fundamental step in building clean and easy-to-understand financial dashboards. For most uses, applying the 'Currency' format from the Modeling tab is the simplest and best solution. If you require more advanced customization, the DAX FORMAT function offers powerful control, as long as you remember that it converts your numbers to text.

Building effective reports often involves pulling data from multiple sources and manually formatting everything, which can quickly consume your day. At Graphed, we've automated this process so you can get insights faster. After connecting your data sources, you can use plain English to tell Graphed something like "create a dashboard showing our Shopify revenue vs. Facebook Ads spend for this month," and it builds a live, professional dashboard for you - pre-formatted and ready to go. We handle the data wrangling so you can focus on making decisions, not on clicking menus.

Related Articles