How to Reduce Decimal Places in Power BI

Working with long, unwieldy decimal numbers in Power BI can make your reports look cluttered and feel imprecise. Fortunately, trimming them down is simple once you know where to look. This article will walk you through several easy methods to reduce or control decimal places in Power BI, from quick formatting fixes to more powerful DAX functions.

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 Is Managing Decimal Places So Important?

Before jumping into the "how," it's worth understanding the "why." Controlling the number of decimal places in your reports isn't just about appearances, it directly impacts how your audience interprets the data.

• Improves Readability: Numbers like "$5,123.87" are far easier to read and compare than "$5,123.873917". Removing unnecessary decimals cleans up your visuals, making them less distracting and easier to scan.
• Avoids a False Sense of Precision: Displaying seven decimal places on a sales figure might suggest a level of accuracy that doesn't actually exist and isn't relevant to the business decision at hand. Showing just two decimal places for currency is standard and more practical.
• Saves Space on the Canvas: Less is more, especially on a crowded dashboard. Shorter numbers mean you can fit more information into visuals like tables and matrices without them looking cluttered or requiring horizontal scrolling.

Method 1: The Quickest Fix Using the Modeling Tab

For formatting an entire column or measure universally across your report, the Modeling tab is your best friend. This is the most common and fastest way to set your decimal places.

Follow these steps:

1. In the Data pane on the right-hand side, find and click on the measure or column you want to format. This will select it and bring up contextual tabs in the top ribbon.
2. With the field selected, click on the Modeling tab in the ribbon.
3. Look for the Formatting section. Here, you will see a text box next to the percentage or dollar sign symbols. This box controls the number of decimal places.
4. Enter your desired number (e.g., 0, 1, or 2) and hit Enter.

That's it! Every visual in your report that uses this measure or column will now automatically update to reflect the new formatting. For example, if you change a sales revenue measure to two decimal places, all your cards, charts, and tables using that measure will now display values like $14,350.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

Method 2: Customize Specific Visuals in the Format Pane

Sometimes you need different formatting for the same data in different places. For instance, you may want a high-level summary card to show a whole number ("$5M Revenue"), but a detailed table on another page needs to show the exact cents ($5,001,432.18). This is where formatting individual visuals comes in.

Here's how to do it:

1. Click on the specific visual you want to change on your report canvas.
2. Go to the Visualizations pane and click the "Format your visual" icon, which looks like a paintbrush.
3. Navigate to the section that controls the data values. The name of this section depends on the visual type:
4. Expand the section and look for an option named Value decimal places.
5. Type in the desired number of decimals for that visual only.

This method provides great flexibility, allowing you to tailor the level of detail presented in each part of your report without changing the underlying measure's default formatting.

Method 3: Advanced Control with DAX Functions

For ultimate control and dynamic formatting based on conditions, you can use Data Analysis Expressions (DAX). The two main functions for this purpose are ROUND and FORMAT, and it's essential to understand the difference between them.

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

Using the ROUND Function

The ROUND function reduces the decimal places of a number while keeping its data type as a number. This is crucial because it means you can still use the output in further mathematical calculations (like sums or averages) and on chart axes.

The syntax is simple:

ROUND(<,number>, <,num_digits>)

Here's an example of creating a new measure from an existing revenue field to round it to two decimal places:

Revenue Rounded = ROUND(SUM(Sales[SaleAmount]), 2)

You can also use 0 to round to the nearest whole number:

Revenue Whole Dollar = ROUND(SUM(Sales[SaleAmount]), 0)

When to use ROUND: Use this function when you need to mathematically round a number before using it in other calculations or charts.

Using the FORMAT Function

The FORMAT function is incredibly powerful for displaying numbers exactly as you wish, but it has one very important characteristic: it converts the number into a text string.

Because the output is text, you can't perform mathematical operations on it, and it won't work correctly on a chart's value axis. It's best used for final outputs in visuals like Cards, Tables, and Matrices.

The syntax is:

FORMAT(<,value>, <,format_string>)

Here are a few common use cases:

• To show two decimal places:

Revenue (2 Decimals Text) = FORMAT(SUM(Sales[SaleAmount]), "0.00")

• To show as a whole number with commas:

Revenue (No Decimals Text) = FORMAT(SUM(Sales[SaleAmount]), "#,##0")

• To display currency with zero decimal places:

Revenue (Currency Text) = FORMAT(SUM(Sales[SaleAmount]), "$#,##0")

When to use FORMAT: Use this when you care primarily about the display of the final number in a visual and do not need to use the result in any other calculations.

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

Which Method is Right for You? A Quick Guide

With several options available, here’s a simple cheat sheet to help you decide which method to use:

• For formatting a measure or column consistently across your entire report: Use the Modeling Tab. It’s the fastest and most straightforward approach.
• For applying special formatting to only one specific visual: Use the Format Pane (the paintbrush icon). It gives you granular control without affecting your other visuals.
• To permanently round a number for use in more calculations while keeping it a number: Use the ROUND DAX function.
• To create a custom-formatted number for display in a table or card and don't need to do more math with it: Use the FORMAT DAX function.

Final Thoughts

Adjusting decimal places is a small change that makes a big difference in the quality and professionalism of your Power BI reports. By using the Modeling tab for general formatting, the Format pane for specific visuals, and DAX functions like ROUND and FORMAT for more complex scenarios, you have complete control over how your data is presented.

Manually formatting visuals and writing DAX formulas in Power BI is a common part of building reports, but it still takes time. We built Graphed to streamline this entire process. Instead of clicking through panes or writing functions, you can just ask in plain English, "Show me total sales by country with no decimal places," and it instantly creates a clean, pre-formatted chart for you. It's a great way to get straight to an insight without getting bogged down in formatting details.