How to Format Numbers in Power BI

Formatting numbers in Power BI is essential for turning a good report into a great one, making your data easy to understand at a glance. Mastering this skill ensures your audience can quickly grasp the story your data is telling, whether it's about sales revenue, website conversion rates, or project completion percentages. This guide will walk you through the most practical ways to format numbers in Power BI, from simple currency and percentage formatting to more advanced conditional and custom formats using DAX.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Does Number Formatting Matter?

Clean and consistent number formatting isn't just about making your reports look pretty, it's about clarity and accuracy. Imagine seeing a table with revenue figures like 50432.1, 123145.67, and 9834. Without formatting, viewers have to mentally parse these numbers to understand their scale. Are they dollars? Are they user counts? Adding a dollar sign, a thousands separator, and consistent decimal places - like $50,432.10, $123,145.67, and $9,834.00 - instantly provides context.

Good formatting helps with:

• Better Readability: Consistent formatting helps users scan and digest information faster.
• Reduced Errors: It prevents misinterpretation of data (e.g., confusing 50.000 with 50,000 in regions where decimal conventions differ).
• A Professional Look: Well-formatted reports appear more polished and credible, building trust with your stakeholders.

The Basics: Using the Formatting Pane

Power BI’s most straightforward formatting tools are available directly in the user interface, no code required. These settings are usually associated with the specific column or measure in your data model.

To access these options, go to the Report View or Data View, select the data field (column or measure) you want to format from the Data pane on the right. When you select it, a contextual tab will appear in the top ribbon: either Column tools or Measure tools.

This is your primary control center for basic formatting.

Graphed

Still Building Reports Manually?

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

Watch the Demo

How to Format Currency

One of the most frequent formatting tasks is correctly displaying currency. Here’s how to do it:

1. Select the measure or column containing your monetary values (e.g., 'Total Sales') in the Data pane.
2. With the field selected, go to the Measure tools (or Column tools) tab in the ribbon.
3. In the Formatting section, click the dropdown list that likely says 'General.' Select Currency.
4. Power BI will likely default to your local currency. To change it, click the small dollar sign icon dropdown in the same section and select the appropriate symbol (e.g., $, £, €, etc.).
5. You can also adjust the number of decimal places in the box next to the formatting options. For finance, two decimal places are standard, but for high-level dashboards, you might prefer zero.

How to Format Percentages

Percentages are critical for showing proportions, like conversion rates or market share. To apply percentage formatting:

1. Select the measure or column you want to format (e.g., 'Conversion Rate').
2. Navigate to the Measure tools or Column tools tab.
3. In the Formatting group, simply select Percentage from the format dropdown or click the % icon.
4. Power BI automatically multiplies the number by 100 and adds the percentage symbol. For example, a raw value of 0.05 will be displayed as 5.00%.
5. You can adjust the number of decimal places here as well to control precision.

How to Format Whole and Decimal Numbers

For general numbers, like quantities, counts, or scores, you have several options.

• Whole Numbers: If your field should never have decimals (like 'Units Sold'), select Whole number from the dropdown and set decimal places to 0.
• Decimal Numbers: For numbers that require precision, select Decimal number and specify the number of decimal places.
• Thousands Separator: A vital feature for readability is the thousands separator. You can toggle this on or off by clicking the comma icon in the Formatting group. This will change 1500000 to the much more readable 1,500,000.

Drilling Down: Conditional Formatting

Conditional formatting changes the appearance of a number based on rules you define. It's a powerful way to draw immediate attention to key data points, like highlighting underperforming products in red or top-performing sales reps in green.

You apply conditional formatting within a specific visual. Let's use a Table visual as an example:

How to Add Background Color Based on Value

1. Select your table or matrix visual on the report canvas.
2. In the Visualizations pane, click the paintbrush icon to open the Format your visual options.
3. Expand the Cell elements section.
4. You'll see a list of the fields in your visual. Find the one you wish to format (e.g., 'Sales Amount') and toggle the Background color switch to On.
5. Click the fx button next to the toggle to open the advanced formatting window.

In this window, you have a few ways to format:

• Gradient: Creates a color scale from a minimum to a maximum value. Useful for heatmaps.
• Rules: Lets you set specific conditions. This is often the most useful option.
• Field value: Formats based on the value of another field, which typically contains a color name or hex code (an advanced technique).

To set up a rule-based format:

1. In the Format style dropdown, select Rules.
2. Define your rules. For instance, to highlight sales figures:
3. Click OK. Your table will now instantly update, coloring the cells based on those rules.

You can use the same process for Font color, Data bars, and Icons under the Cell elements section to create highly intuitive and actionable tables.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Advanced Techniques: Custom Formatting with DAX

Sometimes the built-in formatting options aren't quite enough. If you need a completely custom format - like displaying phone numbers, adding text prefixes/suffixes, or creating unique date formats - you need the DAX FORMAT function.

The FORMAT function takes a value (like a number or date) and converts it into a text string based on a format code you provide.

Syntax:

FORMAT(<value>, <format_string>)

Important Note: Because FORMAT converts the output to text, you can no longer use it in calculations that require a numeric data type (like summing it up). It’s best used for display purposes, either by creating a new calculated column or measure specifically for visualization.

Example 1: Formatting Large Numbers with K/M/B

For executive dashboards, showing $1,500,000 is often less impactful than $1.5M. Here’s a DAX measure to achieve that cleanly:

Profit Display = FORMAT([Total Profit], SWITCH(TRUE(), ABS([Total Profit]) >= 1000000000, "$0.0,,,.0B", ABS([Total Profit]) >= 1000000, "$0.0,,.0M", ABS([Total Profit]) >= 1000, "$0,.0K", "$0" ) )

This DAX measure checks the magnitude of the [Total Profit] and applies the appropriate abbreviation. It converts values like 1,540,800 into $1.5M.

Example 2: Custom Phone Number Format

Let's say you have a 10-digit number like 5551234567 and you want to display it as (555) 123-4567. You can create a new calculated column with this DAX formula:

Formatted Phone = FORMAT('Customer'[PhoneNumber], "(000) 000-0000")

Graphed

Still Building Reports Manually?

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

Watch the Demo

Example 3: Showing Positive/Negative Values with Symbols

You can use special format codes to dictate how positive, negative, and zero values are displayed. The format codes are separated by semicolons (,). (Positive, Negative, Zero)

For example, to show growth percentages with an up arrow for positive and a down arrow for negative:

MoM Growth Pct = FORMAT([Month over Month Growth], "▲ 0.0%, ▼ 0.0%, -")

This formula will display 0.15 as ▲ 15.0% and -0.05 as ▼ 5.0%.

Best Practices for Number Formatting

Knowing how to format numbers is only half the battle. Knowing when and why is just as important.

• Be Consistent: If you format revenue in USD with two decimal places on one page, do it on all pages. Consistency builds a predictable and easy-to-navigate report.
• Consider Your Audience: A financial analyst might need four decimal places for precision, but a C-level executive will probably prefer numbers rounded to the nearest thousand or million (e.g., $5.4M). Tailor your formatting to their needs.
• Don't Overdo It: Conditional formatting is powerful, but a table full of clashing colors and icons creates visual noise. Use it sparingly to draw attention to what's most important, not to color everything.
• Use Whitespace: A dashboard that is CRAMMED with numbers is one of the hardest things for most users to consume - instead of just showing numbers everywhere, think about what is MOST important to show on the page. Cut out any numbers or charts that are not driving towards making better and easier decisions.

Final Thoughts

Taking a few moments to properly format numbers can dramatically elevate the quality and usability of your Power BI reports. By moving beyond default settings and using the formatting pane, conditional rules, and custom DAX functions, you can present your data in a way that is immediately clear, insightful, and professional.

Mastering these details is a crucial step, but it often comes after the time-consuming process of connecting data sources and building your initial reports. At Graphed , we automate that front-end work. We allow you to connect all your marketing and sales data sources (like Google Analytics, HubSpot, or Shopify) and then create real-time, functional dashboards simply by describing what you want in plain English. We handle the connections and build the visualizations on the fly, so you can spend less time wrangling data and more time uncovering actionable insights.