How to Stop Power BI from Rounding

It’s a familiar story: you build the perfect Power BI card to show a key metric, only to see "1.0M" instead of the "987,654" you were expecting. Power BI’s automatic number scaling is designed to keep dashboards tidy, but for detailed reports, that rounding can hide crucial details or just be plain frustrating. Fortunately, you have complete control over how your numbers are displayed.

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

This tutorial will show you exactly how to stop Power BI from rounding your numbers in cards, tables, matrices, and charts. We'll cover simple visual formatting tweaks as well as more advanced DAX functions for ultimate precision.

Why Does Power BI Round Numbers in the First Place?

Power BI’s default behavior is to make large numbers easier to read at a glance. It automatically applies "display units" to condense numbers into thousands (K), millions (M), billions (B), or even trillions (T). Seeing "2.5M" is often faster to digest on a high-level dashboard than reading "2,534,891".

This feature, called Auto Display Units, is undeniably helpful for summarizing data on executive dashboards where the big picture is more important than the exact figures. The problem arises when this default setting is applied to analytical reports where stakeholders need to see precise values for accounting, in-depth analysis, or operational reviews. In these cases, rounding can lead to misinterpretations and a loss of confidence in the data.

The goal is to know when and how to turn this feature off so your reports always show the level of detail your audience requires.

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

The Easiest Fix: Changing Display Units for a Visual

For most visuals like Cards, KPI cards, gauges, and chart axes, the fix is a simple settings adjustment. You just need to tell Power BI to stop automatically formatting the number and show the raw value instead.

Let's say you have a Card visual displaying total sales, and it's showing "124K" instead of the exact "123,567".

Step-by-Step Instructions:

1. Select the Visual: Click on the card or chart you want to adjust. This will highlight it and bring up the visualization-specific panes on the right-hand side.
2. Go to the Formatting Pane: In the “Visualizations” pane, click on the icon that looks like a paintbrush. This is the “Format your visual” section.
3. Find the Value to Format: You'll need to locate the specific data value you want to change. The name of this section varies depending on the visual type:
4. Change Display Units to "None": Scroll down within that section until you find the "Display units" dropdown. Click on it and change the selection from "Auto" to "None".

Instantly, your visual will update to show the full, unrounded number: "123,567". It’s as simple as that. This single change is usually enough to solve rounding issues in most of your summarized visuals.

How to Control Decimal Places for Finer Detail

Sometimes, setting "Display units" to "None" isn't the final step. You might be working with percentages, averages, or currency where the decimal points are being rounded. For instance, a KPI showing an exact conversion rate of 99.78% might be rounded up to 100%, which is misleading.

To fix this, you need to adjust the formatting of the underlying data field (the measure or column itself), not the visual.

Step-by-Step Instructions:

There are two primary places you can control this formatting in Power BI Desktop.

1. Using the Ribbon

This is the most direct method and works whether you're in the Report view, Data view, or Model view.

1. Select the Data Field: On the right-hand side of your screen in the "Data" pane, click on the measure or column whose formatting you want to change (e.g., your "Conversion Rate" measure).
2. Use the "Measure Tools" or "Column Tools" Ribbon: Once the field is selected, a new contextual tab will appear in the main ribbon at the top of the Power BI window. If you selected a measure, you'll see "Measure tools". If you selected a column, you'll see "Column tools".
3. Adjust the Formatting: In the "Formatting" section of this ribbon, you will see a text box where you can directly type the number of decimal places you want to see. For our Conversion Rate example, you would type '2', press Enter, and every visual using that measure will now display two decimal places (99.78%).

You can also use this same ribbon to change the data type to a percentage, currency, or add a thousands separator directly.

2. Using the Report View Data Pane

You can achieve the same result without leaving the main report canvas.

1. Select the field in the Data pane.
2. With the field still highlighted, look back at the "Visualizations" pane. Right beside "Format", look for the “Type-specific formatting” icon — it looks like a data columnar table. It’s easy to miss but provides direct access to the measure-formatting functions. From here, you have all the options located in the ribbon but localized for contextual convenience while authoring your reports.

Remember, making this change at the field level is a global change across your report. Every visual using that specific field will automatically inherit the new decimal formatting, ensuring a consistent level of precision everywhere.

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

Fixing Rounding in Tables and Matrices

Tables and Matrices behave a little differently. They don't have a visual-level "Display units" setting you can toggle on or off in the formatting pane. Why? Because these visuals are designed to show raw, detailed data, and precision is typically expected field by field.

If you see rounded numbers in a table or matrix (like your Sales column showing "$124K"), the problem isn't with the visual — it's with the formatting of the underlying measure or column. The solution is the exact same one we just covered in the previous section on controlling decimal places.

Here’s the process specifically for a Table:

1. Look at your table and identify the column containing rounded figures. Let's say it's a "Revenue" column.
2. In the “Data” pane on the right of your screen, find and click on your "Revenue" measure or column.
3. With the field selected, a "Measure tools" or "Column tools" tab appears. Go to the "Formatting" section of the top ribbon.
4. Here, you can set the Data format type. Let's select currency and set the decimal places to '2'.

Your table will immediately update. The "Revenue" column will no longer show "$124K," but will instead display "$123,567.00," giving you the precision needed for a detailed financial report.

Using DAX for Ultimate Formatting Control (Advanced)

For the ultimate control over how numbers appear, you can turn to the FORMAT function in DAX. This function converts a number into a text string based on a specific format code you provide.

You might use the FORMAT function when:

• You need unique formatting in only one specific visual, without changing the default formatting of the measure everywhere else.
• You want to apply complex formatting, like adding commas for thousands, country-specific currency symbols, or displaying leading zeros.

To use it, you create a new measure. Don't try to modify your existing numerical measure.

Example:

Let’s say you have a measure called [Total Sales]. To create a formatted version with a thousands separator and two decimal places, you would create a new measure with this DAX formula:

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

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

Explanation of the Format String:

• # is a digit placeholder that only shows significant digits and doesn't display leading or trailing zeros.
• , is the thousands separator placeholder.
• 0 is a digit placeholder that will display insignificant zeros if the number doesn't have enough digits. For example, using ".00" will show a value like 45 as "45.00".

You can then drag this new Formatted Sales measure into your visual instead of the original one.

Important Warning: The FORMAT function converts your number into a text type. This text may look perfectly numerical but is no good for mathematical processes. When Power BI sees that a string value, sorting numbers will be incorrect (e.g., 1, 10, 100, 2, 20 ...) or attempts using 'if' tests could lead to unexpected results.

Best Practice:

Keep them separate by creating explicitly formatted measures when they are going to need any type of mathematical handling in some way within your model. Have a separate format for any data used visually, and leave a purely numerical version for calculations.

Final Thoughts

Controlling rounding in Power BI is essential for creating clear, accurate, and trustworthy reports. You can easily manage most issues by switching the "Display units" field for visuals to 'none', adjusting column or measure formats directly so that they work correctly within every visual, using advanced DAX functions like 'Format' which allows us much greater control. These techniques will allow you to create dashboards and reports exactly how your audience wants to see them!

While tweaking field formatting is a normal part of building reports, we believe analyzing your data should be faster and more intuitive. That's why we built Graphed to remove these manual steps. It's an AI-powered data analyst that connects to your key marketing and sales platforms and builds real-time dashboards for you. Simply ask a question in plain English, like "show me our total sales by region last month as a table with two decimal places," and Graphed handles the rest — letting you focus on insights, not settings.