How to Format a Measure in Power BI

Nothing can derail a beautiful Power BI report faster than messy formatting. Having your sales figures show up as long, unreadable numbers or your market share as a long decimal defeats the whole purpose of creating an easy-to-read dashboard. This guide will walk you through exactly how to format measures in Power BI, starting with the simple, built-in tools and then moving on to more powerful DAX functions for custom and dynamic formatting.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Is Formatting Measures in Power BI So Important?

Formatting is about more than just making things look neat, it’s about making your data understandable at a glance. When a stakeholder looks at your dashboard, they shouldn't have to squint and count zeros to figure out if they’re looking at ten thousand dollars or one million.

Proper formatting ensures:

• Clarity and Readability: Numbers like $1,345,987.55 and 75.3% are instantly recognizable, whereas 1345987.5543 and 0.753 require mental effort to interpret.
• Professionalism and Trust: A well-formatted report shows attention to detail, which builds trust with your audience. Inconsistent or poor formatting can make the underlying data seem less credible.
• Consistent User Experience: When all currency values in a report are formatted the same way and all percentages have the same number of decimal places, users can navigate and understand your dashboard much more quickly.

Let's dive into the different ways to control how your numbers are displayed.

The Easiest Method: Using the 'Measure Tools' Ribbon

For 90% of your formatting needs, this is the way to go. When your measure will have the same format everywhere it's used in your report - all sales figures should be currency, all profit margins should be a percentage - the tools in the Power BI ribbon are the simplest and most effective solution. This method changes the base formatting of the measure itself, keeping it as a number that can be used in any chart or calculation.

Imagine we have a simple measure to calculate total sales:

Total Sales = SUM('Sales'[Revenue])

By default, if this measure shows up in a card visual or a table, it might look like 1507342.68. Here's how to fix it step-by-step:

1. Select the Measure: In the Fields pane on the right side of your Power BI canvas, click on your measure (Total Sales, in this case).
2. Open the Measure Tools Tab: When you select the measure, a new contextual tab called Measure tools will appear in the top ribbon. Click on it.

Here, you'll find a formatting section with all the common options you need.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How to Format Currency in Power BI

To format our Total Sales measure as currency:

1. With the measure selected and the Measure tools tab open, click the dropdown arrow next to the word "General" in the Format box.
2. Select Currency. Power BI will apply your default currency settings.
3. To change the currency symbol, click the dollar sign icon in the formatting group. You can search for and select other currency symbols like the Euro (€), British Pound (£), and many others.

Now, our measure will display as $1,507,342.68 everywhere it's used. You can also easily adjust the number of decimal places here.

How to Format Percentages in Power BI

Let’s say you have a profit margin measure like this one:

Profit Margin = DIVIDE(SUM('Sales'[Profit]), SUM('Sales'[Revenue]))

This might show up as 0.2315 initially, which isn't very intuitive. To format it as a percentage:

1. Select the Profit Margin measure in the Fields pane.
2. Under the Measure tools tab, simply click the percent (%) sign in the formatting section.
3. Power BI will instantly convert it to 23.15%. You can then adjust the number of decimal points as needed using the decimal adjuster in the same section.

Working with Commas and Decimals

The Measure tools ribbon also gives you one-click access to add a thousand separator (the comma) for large numbers that aren’t currency, and precise control over how many decimal places are displayed for any numerical format.

Dynamic and Custom Formatting with the DAX FORMAT Function

Sometimes, the simple, report-wide formatting from the ribbon isn't enough. What if you want to show millions as "$1.5M" and thousands as "$250K"? Or what if you want to display values differently based on a condition? For these scenarios, you need the DAX FORMAT function.

A Very Important Warning: The FORMAT function converts your number into a text value (a string). This has a massive implication: you can no longer use its output on chart axes that require numbers, like line charts or scatter plots, and you can't use it in other calculations. Once a number becomes text, it can only be displayed. You should only use the FORMAT function for display purposes, typically inside tables, matrices, or card visuals.

The syntax is simple:

FORMAT(<value>, <format_string>)

Here are some of the most useful format strings to know:

• "General Number": Displays the number with no specific formatting.
• "$#,##0.00": Formats as currency with a dollar sign, thousand separators, and two decimal places.
• "#,##0": A whole number with thousand separators.
• "0.0%": A percentage with the 0 as a placeholder that always displays a digit, even if it's zero.
• "#,###.0": A number with one decimal place and a thousand separator. The # is a placeholder that only displays digits if they exist.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How to Use The FORMAT Function for Dynamic Labels

Now for the cool part. Let’s create a new measure that automatically shows large numbers abbreviated with K (thousands), M (millions), or B (billions).

Here’s a measure that formats Total Sales dynamically:

Formatted Sales = VAR SalesValue = [Total Sales] RETURN SWITCH( TRUE(), SalesValue >= 1000000000, FORMAT(SalesValue / 1000000000, "$0.0B"), SalesValue >= 1000000, FORMAT(SalesValue / 1000000, "$0.0M"), SalesValue >= 1000, FORMAT(SalesValue / 1000, "$0.0K"), FORMAT(SalesValue, "$#,##0") )

When you use this Formatted Sales measure in a table or card visual, a value of 1500000 will appear as $1.5M, and a value of 25000 would appear as $25.0K. Just remember, the output is text!

Power BI Formatting Best Practices

Getting formatting right can elevate your dashboard from a data dump to an insightful tool. Here are a few best practices to keep in mind.

1. Stay Consistent Across Your Report

Ensure that all similar metrics are formatted identically. If revenue is shown with two decimal places on one page and zero on another, it creates cognitive dissonance for your users. Define your formatting standards and stick to them.

2. Format for Your Audience

Consider who will be viewing the report. An executive dashboard might be better with simplified numbers (like $1.5M), while a financial analyst needs to see the exact figures ($1,507,342.68). Tailor your presentation to the audience’s needs.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

3. Use the Measure Tools Ribbon by Default

Always start with the simplest tool for the job. The Measure tools ribbon sets the default format without converting the data type. This is what you should use for most of your measures.

4. Use the DAX FORMAT Function with Caution

Reserve the DAX FORMAT function for those specific cases where you need dynamic text labels in tables, matrices, or cards. Never apply it to a base measure you intend to use in other charts or calculations. Create a separate, "formatted" version of your measure instead.

5. Consider Regional Settings

Be mindful that different regions use different separators (. vs. ,) and currency symbols. Power BI's built-in options generally respect regional settings, but if you create custom formats with DAX, be sure to hardcode the correct symbol for your audience (e.g., "€#,##0.00").

Final Thoughts

Mastering how you format measures is a fundamental skill that transforms your Power BI reports from functional to fantastic. Whether you're using the straightforward formatting options in the ribbon or crafting complex, dynamic abbreviations with DAX, the goal is always the same: to make your data as clear, readable, and impactful as possible.

All this manual configuration adds up. Setting up data connections, writing DAX measures, and carefully formatting each visual takes hours of focused work that pulls you away from finding actual insights. With Graphed , we aim to eliminate this friction entirely. We’ve designed a platform where you can connect your data sources in minutes and use simple, conversational language to build fully interactive, real-time dashboards. Rather than wrestling with format strings, you can just ask what you want to see, and let our AI handle the rest - getting your team the answers they need in seconds, not hours.