How to Add in Power BI

Displaying numbers as currency in Power BI is a fundamental task, but one that can trip people up. Whether you're building a sales report or a marketing budget dashboard, simply showing 150000 instead of $150,000.00 can make your report look unprofessional and hard to read. This guide will walk you through the various ways to add a dollar sign ($) and properly format your numbers as currency in Power BI.

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," it's worth a quick mention of the "why." Proper formatting is about more than just aesthetics, it's about clarity, context, and professionalism.

• Clarity: A dollar sign immediately tells your audience that they are looking at a monetary value. It removes ambiguity and makes charts and tables easier to understand at a glance.
• Context: Is 50.25 a quantity, a percentage, or a price? The '$' sign provides instant context, preventing misinterpretation of your data.
• Professionalism: A well-formatted report demonstrates attention to detail. It builds trust with your stakeholders, assuring them that the data is not only accurate but also presented thoughtfully.

Now, let's get your numbers looking sharp.

The Easiest Method: Using the Formatting Pane

For most situations, the quickest and most reliable way to format numbers as currency is by using the formatting tools built directly into the Power BI interface. This method changes the display format without altering the underlying data type, meaning you can still perform mathematical calculations on your formatted numbers.

Follow these simple steps:

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

Step 1: Select Your Data

First, navigate to the Report View, Data View, or Model View. It works in all three. In the Data pane on the right side of your screen, find and click on the specific column or measure you want to format. For this example, let's say we have a measure called "Total Sales." Clicking it will highlight it.

Step 2: Access the Formatting Tools

Once you've selected your field, a content dashboard will appear in the toolbar at the top called either Column tools or Measure tools, depending on what you selected. Both tabs have a group of settings called Formatting.

Step 3: Apply Currency Formatting

Within the Formatting group, you will see a text box for "format" and beside it there's a dollar sign icon ($) with a drop-down arrow next to it, which you can use to select your currency format. Alternatively, you can change "General" to "Currency" for a specific format.

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

Step 4: Control Your Decimal Places (Optional)

If you don't need the default two decimal places, you can adjust them. With your field still selected, locate the decimal places option under the Formatting area, and adjust as needed.

More Control with the FORMAT Function in DAX

Sometimes you’re seeking greater control over your formatting or want to include text with your results. This is possible using Data Analysis Expressions (DAX) in Power BI. DAX allows for custom formula-based formatting.

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

Breaking Down the DAX Formula:

• Formatted Sales =: This is the name of the new measure we are creating.
• FORMAT: This DAX function converts a value to text with a specified format.
• 'Sales'[Total Revenue]: This is the existing column or measure containing the numeric value we want to format.
• "$#,##0.00": This is the format string, where each part specifies part of the format.

A Huge Warning About FORMAT()!

The FORMAT function always returns a text (string) data type. This means that formatted measures cannot be used in mathematical operations.

Advanced Scenario: Dynamic Currency Symbols with DAX

Consider international sales data that includes multiple currencies. Using DAX, you can create custom fields that dynamically adjust currency symbols based on the country.

SWITCH(
    TRUE(),
    SELECTEDVALUE('Sales'[Country]) = "United States", FORMAT([Total Revenue], "$#,##0.00"),
    SELECTEDVALUE('Sales'[Country]) = "Canada", FORMAT([Total Revenue], "C$#,##0.00"),
    SELECTEDVALUE('Sales'[Country]) = "Australia", FORMAT([Total Revenue], "A$#,##0.00"),
    FORMAT([Total Revenue], "$#,##0.00") // Fall-back option
)

The SWITCH statement checks the 'Country' column to apply the correct currency symbol 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

Troubleshooting Common Formatting Issues

Here are ways to solve common issues with currency formatting in Power BI:

1. "$ Symbol Won’t Appear at All!"

• Check Data Type: Make sure your column is set to a number data type, not text. This ensures Power BI formats it correctly. Use the 'Transform' tab to modify data types as needed.
• Sorting Issues: If your numbers aren't sorting correctly, it may be due to custom sorting settings that conflict with numeric sorting. Ensure your fields are sorted as numbers rather than strings.

Final Thoughts

Proper currency formatting in Power BI enhances your reports' clarity and professionalism. Whether using the built-in formatting options or DAX functions for customization, these techniques will help showcase your data effectively. Use these methods to maintain numeric types for basic tasks and leverage DAX for complex needs, ensuring your reports are both informative and visually appealing.

At Graphed, we use these tools to create insightful dashboards. By integrating various tools, you can gain unique insights without extensive DAX knowledge. Experience the power of simplified data presentation with our platform.