How to Round Numbers in Power BI

Working with long, messy decimal numbers in Power BI reports can make your beautifully designed dashboards look cluttered and hard to read. Fortunately, you can easily clean up your data by rounding numbers to just the right level of precision. This article walks you through the practical DAX functions and formatting options you can use to control how numbers are displayed in your reports.

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 Should You Round Numbers in Power BI?

Rounding numbers isn't just about making things look tidy, it serves a few important purposes for data clarity and business logic:

• Improved Readability: Numbers like $345,678.91 are much easier for your audience to digest than $345,678.913572. Removing unneeded decimal places makes KPIs and metrics in tables and cards easier to read at a glance.
• Better Chart Visualization: In charts and graphs, long decimals on your data labels or axes can create visual noise. Rounding them makes your visuals cleaner and more professional.
• Aligning with Business Rules: Sometimes, business context requires specific rounding. For example, when dealing with currency, you almost always want to round to two decimal places. For inventory, you might want to round down to the nearest whole number because you can't sell a fraction of a product.

Getting Started: New Columns vs. Measures

In Power BI, you'll use DAX (Data Analysis Expressions) formulas to round numbers. You can apply these formulas in two primary ways: by creating a calculated column or by creating a measure. Choosing the right one depends on your goal.

Calculated Columns

A calculated column adds a new column to your existing data table. The rounding calculation is performed for each row in that table and the result is stored. This is useful when you want to use the rounded value as a filter, in a slicer, or in future row-by-row calculations.

Measures

A measure calculates a value on the fly based on user interactions with the report (like filtering). Measures are for aggregations, such as a sum or average. You use DAX to round the result of the aggregation. This is the best choice when rounding a KPI or a total to be displayed in a card, chart, or matrix visual.

How to Use the ROUND Function in DAX

The ROUND function is the most common and versatile tool for rounding. It follows standard mathematical rules, rounding numbers less than 5 down and numbers 5 and greater up.

The syntax is simple:

ROUND(<,number>, <num_digits>)

• <,number>: The number or column you want to round.
• <,num_digits>: How many decimal places you want to round to.

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

Example 1: Rounding to Two Decimal Places (Currency)

Let's say you have a 'Sales' table with a 'ProductPrice' column containing values like 19.9912. To clean this up for financial reporting, you can create a new calculated column that rounds the price to two decimal places.

1. Navigate to the Data view in Power BI and select your 'Sales' table.
2. From the 'Column tools' section in the ribbon, click "New column."
3. In the formula bar, enter the following DAX expression:

Rounded Price = ROUND('Sales'[ProductPrice], 2)

This creates a new "Rounded Price" column where 19.9912 becomes 19.99, and 25.45 becomes 25.46.

Example 2: Rounding to the Nearest Whole Number

Imagine you have an 'Order' table with an 'AverageItemsPerOrder' column showing 3.7. For a summary report, you might want to show this as the nearest whole number. You can do this by setting <,num_digits> to 0.

In a new measure, the formula would look like this:

Avg Items Rounded = ROUND(AVERAGE('Orders'[ItemsPerOrder]), 0)

This will calculate the average of the 'ItemsPerOrder' column and then round the final result. For example, an average of 3.7 would become 4, and 3.4 would become 3.

Example 3: Rounding to the Nearest 10, 100, or 1000

A little-known trick with the ROUND function is using negative numbers for <,num_digits> to round to the left of the decimal point. This is incredibly helpful for cleaning up large numbers like website traffic or impression counts.

• To the nearest 10: Use -1. For example, ROUND(12345, -1) becomes 12,350.
• To the nearest 100: Use -2. For example, ROUND(12345, -2) becomes 12,300.
• To the nearest 1000: Use -3. For example, ROUND(12345, -3) becomes 12,000.

Let's say you have a measure for total 'Website Sessions'. A new measure to round it might be:

Sessions Rounded to Hundreds = ROUND([Total Website Sessions], -2)

This is perfect for high-level dashboard KPIs where exact precision isn't necessary and can be distracting.

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

Directional Rounding: ROUNDUP and ROUNDDOWN

Sometimes you need more control than standard rounding rules offer. You might need to always round a number up or always round it down, regardless of its value.

ROUNDUP Function

The ROUNDUP function always rounds a number up, away from zero. This is useful for pricing calculations where you want to ensure all potential costs are covered.

The syntax is the same as ROUND:

ROUNDUP(<,number>, <,num_digits>)

For instance, if your calculated advertising cost-per-click is $1.251, you might want to round it up to $1.26 to be safe. The formula in a calculated column would be:

CPC Padded = ROUNDUP('Ad Metrics'[Cost Per Click], 2)

ROUNDDOWN Function

The ROUNDDOWN function always truncates the number, rounding down toward zero. This is ideal for calculating things like employee tenure in full years or determining how many full units of a product you can build with a certain amount of raw material.

The syntax is also the same:

ROUNDDOWN(<,number>, <,num_digits>)

Let's say a customer accumulated 1,489 loyalty points and they get a reward for every 100 points. To calculate how many rewards they've earned, you can use ROUNDDOWN:

Rewards Earned = ROUNDDOWN('Customer Points'[Total Points] / 100, 0)

This formula would divide 1,489 by 100 to get 14.89, and then round it down to 14, indicating the customer has earned 14 full rewards.

Rounding to the Nearest Multiple with MROUND

What if you need to round to a specific multiple, like the nearest quarter-dollar ($0.25) or the nearest 5-minute interval? The MROUND function is built for this.

The syntax is:

MROUND(<,number>, <,multiple>)

• <,number>: The number you want to round.
• <,multiple>: The multiple you want to round to.

For example, if you want all your product prices to end in .00, .25, .50, or .75, you can use MROUND with a multiple of 0.25.

Price to Nearest Quarter = MROUND('Sales'[ProductPrice], 0.25)

A price of $10.11 would be rounded down to $10.00, while a price of $10.15 would be rounded up to $10.25.

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

Formatting as an Alternative to Rounding

Sometimes you only need to change how a number looks, without altering its underlying value. The DAX functions we've covered change the actual data point, which affects any subsequent calculations. If you just want to clean up a visual for display purposes, use Power BI's built-in formatting options.

Here’s the key difference: Formatting is for presentation only, while DAX functions create a new, permanently rounded value.

To format a number:

1. Select a table or chart in your report.
2. Click on the field, measure, or column in that visual that you want to format.
3. In the ribbon, a contextual tab like "Column tools" or "Measure tools" will appear.
4. In the "Formatting" section, you can directly set the number of decimal places.

Voila! The number will appear rounded in your report, but any calculations that rely on it will still use the original, precise value in the background.

Final Thoughts

Mastering rounding in Power BI gives you precise control over your data's clarity and business logic. Whether you're cleaning up financial reports with ROUND, ensuring costs are covered with ROUNDUP, finding whole units with ROUNDDOWN, or aligning to specific pricing with MROUND, DAX provides the tools you need. And for quick visual adjustments, the formatting options are just a click away.

Knowing how to write a DAX formula is a great first step, but as your reports grow, the real challenge becomes managing dozens of calculations and weaving them together into an effective dashboard. That's why we built Graphed to simplify the entire process. Instead of manually writing formulas and dragging fields, you can just connect your data and start asking questions in plain English - like "create a chart showing sales by product category rounded to the nearest dollar." We automatically write the code, generate the visuals, and build real-time, interactive dashboards for you in seconds.