How to Add Currency Symbol in Power BI Card

Showing raw numbers like 25134.50 on a Power BI report card looks unfinished and can be confusing. Transforming that number into a clear, reader-friendly format like $25,134.50 instantly makes your sales or financial data easier to understand. This small change improves clarity and gives your reports a much more professional feel. This guide will walk you through several easy methods for adding currency symbols to your card visuals in Power BI, ensuring your dashboards communicate financial data effectively.

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

Best Practices: Why You Should Format Columns, Not Just Card Visuals

While you can format numbers directly within a single visual, it's a best practice to apply formatting at the column or measure level. Think of it like a "set it and forget it" approach. When you format the original data column or the DAX measure that calculates a value, every visual that uses that data - whether it's a card, a bar chart, a table, or something else - will automatically inherit the correct currency format. This has several key advantages:

• Consistency Across Your Report: No more formatting the same metric over and over again in different charts. You'll ensure your revenue metric, for example, always appears as $10,250, not $10,250.00 in one place and simply 10250 in another. This consistency makes your entire report cleaner and easier for stakeholders to interpret.
• Efficiency and Time Savings: Applying formatting once at the source saves you from the tedious, repetitive task of clicking into every visual to set the format. For complex dashboards with dozens of visuals, this saves a significant amount of time and reduces the chance of making a mistake.
• Simplified Maintenance: What if your organization decides to switch from showing two decimal places to none? If formatting is applied at the column or measure level, you only need to make the change in one spot. All connected visuals will update automatically. If each visual was formatted individually, you’d have to hunt down and update every single one.

Applying formatting at the data source level is a fundamental principle of good Power BI development. It streamlines your workflow, ensures a consistent and professional look, and makes your reports much easier to manage and update over time. Now, let's explore how to implement this effectively.

3 Simple Methods for Adding Currency Symbols in Power BI

Adding currency symbols can be done in a few different places within Power BI. We'll cover the three most common and practical methods, starting with the most recommended approach - formatting the data column itself - and moving on to more specific, flexible options using DAX.

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

Method 1: Using the Column Tools (The Recommended Approach)

This is the simplest and most efficient method for formatting an entire column of data. When you format the column here, any visual you build using this column will automatically display the correct currency symbol and formatting.

1. Navigate to the Data or Model View First, open your Power BI report. Look to the left side of your screen and switch from the Report View (the canvas where you build visuals) to either the Data View (the icon that looks like a spreadsheet) or the Model View (the icon that shows table relationships). The Data View works well because you can see the data values you’re about to format.
2. Select the Column You Want to Format In the Fields pane on the right-hand side, find and click on the specific column that contains the numeric data you want to display as currency. For example, you might look for a column named "Revenue," "SalesAmount," or "Price." Clicking it will highlight the column in the Data View.
3. Apply Currency Formatting from the Column Tools Ribbon With the column selected, a new contextual toolbar will appear at the top of the Power BI window called Column tools. Within this ribbon, you’ll see a Formatting section.

• Click the dropdown menu next to Format. It probably says General or Whole number by default.
• Select Currency from the list. Power BI will instantly try to apply a default currency format.
• To choose a specific currency symbol (like $, €, £, etc.), click the dollar sign symbol ($) right next to the format dropdown. A long list of world currencies will appear. Scroll to find and select your desired symbol, such as "US dollar ($)" or "Euro (€)".

Your entire column is now formatted. When you return to the Report View and drag this field into a card visual, it will automatically show the correct currency symbol, thousands separators, and decimal points.

Method 2: Creating a Formatted Measure with the FORMAT Function (for Greater Flexibility)

In Power BI, measures often use DAX logic like 'SUM' or 'AVERAGE' to calculate values. It's beneficial to apply formatting directly to measures using the FORMAT function. This allows you to define how numbers should appear, even when they're part of complex calculations. Here's how:

1. Create a New Measure To begin, you need to create a new measure. You can do this by right-clicking in the fields pane on the table or directly from the toolbar to choose "New Measure." This will give you a space to input the DAX formula.
2. Write the DAX Formula Use the FORMAT function within your DAX expression. For example, if you're calculating total sales, your formula might look like this: FORMAT(SUM('Sales'[SalesAmount]), "$#,0.00") This string ensures that the numbers are formatted with thousands separators and two decimal places.
3. Drag the Newly Created Measure to Your Card Visual When you replace any unformatted version in your visuals, this formatted measure will display the numbers correctly.

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

Method 3: Creating Dynamic Measures with SWITCH Function for Currency Selection

The previous methods are great for static currency symbols, but what if your dashboard needs to accommodate multiple currencies? In such cases, a dynamic approach using the SWITCH function can be beneficial. Here's how:

1. Create a Table for Currency Selection Set up a small table for different currencies. This table might have columns like "Country", "Currency", and "Symbol".
2. Create a Dynamic Measure Use DAX to set a measure that changes based on a selected currency. Your formula might look like: SWITCH(SELECTEDVALUE('Currencies'[Currency]), "USD", FORMAT(SUM('Sales'[SalesAmount]), "$#,0.00"), "EUR", FORMAT(SUM('Sales'[SalesAmount]), "€#,0.00"), "GBP", FORMAT(SUM('Sales'[SalesAmount]), "£#,0.00")) This allows the report user to choose the currency they wish to see, and your visuals will update accordingly.

Final Thoughts

In this guide, we've covered three methods for adding currency symbols to your Power BI visuals. From directly formatting your data columns to creating dynamic measures using DAX, you have the flexibility to choose what best fits your project needs.

I make my BI reports using Graphed. By asking it to show weekly summaries and comparing metrics across different countries, my charts are instantly created without needing to manually write DAX formulas or adjust the Power BI setup repeatedly, making my workflow more productive and allowing me to focus on analysis.