How to Change Data Type to Currency in Power BI

Showing numbers as currency is one of the quickest ways to make your Power BI reports look more professional and easier to understand. Instead of displaying a raw number like "54321.78," you can present it as "$54,321.78," which immediately tells your audience what they're looking at. This article will guide you through several simple methods to change a data type to currency in Power BI, from quick clicks in the main interface to best practices in the Power Query Editor.

Graphed

Your AI Data Analyst to Create Live Dashboards

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

Build Your First Dashboard

Why Correct Formatting Matters

In data analysis, context is everything. Formatting a number as currency in Power BI isn't just about aesthetics, it’s about providing clear and immediate context. When your audience sees a dollar sign, a pound sign, or a euro symbol, they instantly know they’re looking at financial data. This small step has a few big benefits:

• Improved Readability: Currency symbols, thousand separators (commas), and decimal points make large numbers much faster to read and interpret. Comparing $1,250,000 to $950,000 is much clearer than comparing 1250000 to 950000.
• Reduced Errors: It removes ambiguity. A number like "25" could mean anything, but "$25.00" is explicitly a monetary value. This prevents stakeholders from misinterpreting a metric, especially in tables filled with different kinds of numbers.
• Professional Polish: Well-formatted reports show attention to detail. It demonstrates that you’ve prepared the data for presentation, which builds trust and credibility with your audience.

Fortunately, Power BI provides multiple ways to apply currency formatting, whether you're working on a visual, shaping the raw data, or managing your entire data model.

Method 1: Using the Report View (The Quickest Way)

The Report View is where you build your charts and visuals, and it's often the fastest place to apply formatting changes to a specific field. You can directly see the impact on your visual as you make the change.

This is the go-to method when you've already built a chart or table and realize a number field needs to be formatted as currency.

Step-by-Step Instructions:

1. Navigate to the Report View by clicking the chart-like icon at the top of the left-hand sidebar.
2. In the Data pane on the right-hand side, find and click on the field (column) you want to format. For example, you might click on a field named "Revenue" or "SalesAmount".
3. When you select the field, a new ribbon tab called Column tools will appear at the top of the Power BI window.
4. In the "Column tools" ribbon, look for the Formatting section.
5. Click the dropdown menu under the word "Format." It likely says "General" or "Whole number" by default. Select Currency from this list.

Just like that, your selected field will be formatted as currency in all visuals where it's used. Power BI will automatically add a currency symbol, commas, and two decimal places based on your system's regional settings.

How to Change the Currency Symbol

What if your data is in U.S. Dollars but your computer's regional setting defaults to the Euro? No problem. In the same Formatting section of the "Column tools" ribbon, you can easily specify the symbol you need.

AI for Data Analysis

Crash Course

Graphed

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.

Download Free Guide

Step-by-Step Instructions:

1. Click the small dropdown arrow right beside the dollar sign icon.
2. A list of common currency symbols will appear, such as $ English (United States), £ English (United Kingdom), and € Euro (€).
3. Select the currency you need from this list.

Your visuals will instantly update to show the correct currency symbol across your report.

Method 2: Using the Data View

The Data View (sometimes called the Table View) shows you the raw data in a spreadsheet-like format. This is an excellent place to set formatting before you start building your visuals or if you want to format several columns in the same table quickly and efficiently.

Step-by-Step Instructions:

1. Click the Data View icon (it looks like a grid or table) in the left-hand sidebar of Power BI.
2. From the list of tables in the Data pane on the right, select the table you want to work with.
3. Find the column you want to format and click on its header to select the entire column. The column will be highlighted in green.
4. Just like in the Report View, the Column tools ribbon will appear at the top.
5. In the Formatting section, select Currency from the format dropdown and choose your desired currency symbol.

The changes you make here are saved to the data column's properties, so any time you use this field in a new visual, it will automatically have the correct currency format.

Method 3: Using the Model View

The Model View is where you manage relationships between your tables and a great place to set properties for multiple fields across your entire data model. It offers a more centralized way to handle formatting, which is particularly useful in complex projects with many tables.

In this view, you modify properties in the Properties pane instead of the ribbon.

Step-by-Step Instructions:

1. Click on the Model View icon (which looks like three connected boxes) in the left-hand sidebar.
2. On the right side of the screen, in the Data pane, find and select the data field you want to modify.
3. With the field selected, the Properties pane (located below the Data pane) will display its details. If you don't see it, go to the "View" tab on the ribbon and make sure "Properties" is checked.
4. In the Properties pane, scroll down to the Formatting section.
5. Click the Format dropdown menu and choose Currency.
6. A new field called "Currency format" will appear, allowing you to select the exact currency symbol you need.

Method 4: Setting the Data Type in Power Query Editor

Methods 1, 2, and 3 control the display format of your number. Setting the data type in Power Query, however, changes the column at a more fundamental level. This is considered a best practice for clean and reliable data modeling because it ensures your data has the right type the moment it's loaded into Power BI.

Note: Applying the format in Power Query affects the underlying data type. You'll still need to use one of the previous methods (like Data View or Report View) to specify the display format (like the '$' symbol). The goal here is to tell Power BI that this column should always be treated as a number suitable for financial calculations.

Graphed

Your AI Data Analyst to Create Live Dashboards

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

Build Your First Dashboard

Step-by-Step Instructions:

1. From the Home ribbon in the main Power BI window, click on Transform data. This opens the Power Query Editor.
2. In the left-hand Queries pane, select the query (table) that contains the column you want to change.
3. Find the column in the preview window. In the column header, you will see a small icon representing its current data type (e.g., "ABC" for text, "1.2" for decimal, "123" for whole number).
4. Click on this small icon. A dropdown list of data types will appear.
5. Select Fixed decimal number. This type is ideal for currency because it maintains a fixed precision of four decimal places, which helps avoid the tiny floating-point rounding errors that can sometimes occur with financial data.
6. Once you’ve made the change, the icon in the column header will update to a dollar sign ($) symbol. This confirms the type.
7. Click Close & Apply in the top-left corner to save your changes and return to the main Power BI window.

Now, the column has the correct underlying data type. From here, you would typically use the Report or Data view to quickly apply the display format to add your desired currency symbol.

Using DAX for Custom Currency Formatting

What if you need more dynamic control? For example, you want to format numbers in thousands (e.g., $5M instead of $5,000,000) or change the format based on other factors. This is where DAX (Data Analysis Expressions) comes in handy, specifically the FORMAT function.

You can create a new measure or calculated column that uses FORMAT to convert a number to a text string with your desired format.

Example 1: Basic Currency Formatting

This DAX formula creates a new measure that formats the 'Total Revenue' value using the system's default currency settings.

Formatted Revenue = FORMAT(SUM(Sales[Revenue]), "Currency")

Example 2: Forcing a Specific Currency and Format

This formula forces a US dollar format with commas and two decimal places, regardless of regional settings.

Revenue USD = FORMAT(SUM(Sales[Revenue]), "$#,##0.00")

Example 3: No Decimals and Thousands Notation 'K'

Revenue in Thousands = FORMAT(SUM(Sales[Revenue])/1000, "$#,##0K")

Important Warning: The FORMAT function converts your number into a text data type. This means you will not be able to use the resulting measure on the value axis of certain visuals, like line charts or bar charts, as they require a numerical value to plot correctly. This approach works best for displaying values in Cards, KPIs, and columns in Tables/Matrices.

Common Issues & Quick Fixes

1. The "Currency" Format Option is Grayed Out

If you can't select the Currency format option, it's almost always because your data column is not a numeric type. It's most likely set to "Text".

Fix: Select the column and go to the "Column Tools" ribbon. Change the Data type to a numeric option, such as Decimal number or Whole number. The "Currency" formatting option should then become available.

AI for Data Analysis

Crash Course

Graphed

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.

Download Free Guide

2. The Wrong Currency Symbol Appears by Default

Power BI defaults to the currency associated with your computer's Windows regional settings. If you frequently work with multiple currencies, this can be an inconvenience.

Fix: You can quickly override the default in the "Column tools ribbon". As shown in Method 1, just click on the dropdown arrow by the dollar sign icon and choose the correct symbol for your data.

3. My Formatting is Erased Every Time I Refresh My Data Source

This issue typically points to a step in Power Query that is overriding your preferred data type.

Fix: Open the Power Query Editor ("Transform Data") and select the problematic query. In the "Applied Steps" pane on the right, review each step carefully, especially any named "Changed Type." Chances are the original import step automatically converted your column to text. Ensure that a later "Changed Type" step correctly sets it to a numeric type, like "Fixed decimal number," and that no following step changes it back.

Final Thoughts

Changing the data type to currency is a fundamental skill in Power BI that significantly improves the clarity and professionalism of your financial reports. Whether you prefer quick adjustments in the Report View or setting strong foundations in the Power Query Editor, mastering these methods will make your dashboards far more effective.

While perfecting these small but crucial details in Power BI is rewarding, we know that the entire process of reporting - from data connection to visualization - can eat up hours. At times, all you need is a quick, accurate answer without all the clicks. We designed Graphed for exactly this purpose. Instead of manually setting data types and building visuals step-by-step, you can simply connect your data sources and describe what you need in plain English - such as, “Show me total sales compared to last quarter styled as currency.” Graphed instantly builds the dashboard for you, handling the formatting details automatically, turning a tedious process into a 30-second conversation and enabling you and your entire team to make data-driven decisions with greater agility.