How to Change Decimal Places in Power BI Table

Nothing ruins a clean Power BI report faster than messy numbers. You might have profit margins stretching to seven decimal places or sales figures that don't need cents. Controlling the decimal places in your tables is fundamental for creating clear, professional, and easy-to-read reports. This guide will walk you through the simplest ways to format your numbers, from quick clicks in the menu 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 Does Formatting Decimal Places Matter?

Before jumping into the how-to, it’s worth understanding why this small detail is so important. How you present numbers directly impacts how your audience interprets your data. Think about it:

• Readability: A table filled with numbers like $1,457,890.35821 is cluttered and hard to scan. Displaying it as $1.46M or $1,457,890 immediately makes it more digestible.
• Clarity and Context: For key financial metrics, two decimal places are standard and expected. For website session counts, decimals don't make sense at all. The right formatting provides the right context.
• Professionalism: Inconsistent and sloppy formatting makes your analysis look rushed and untrustworthy. Clean, standardized number formats build confidence in your reporting.

Taking a moment to adjust decimal places is a small effort that pays big dividends in how your work is perceived.

Method 1: Using the Ribbon (The Easiest Approach)

For most everyday formatting needs, you don’t need to write a single line of code. Power BI’s built-in formatting tools, located in the prominent "Ribbon" menu at the top, are your best friend. This method works for both existing columns in your data and for new measures you create.

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 a Column in the Data/Table View

This is the most common place to set the default format for a column. Once you set it here, the formatting will carry over to any visual you use that column in.

Follow these steps:

1. Navigate to the Data View or Model View: On the left-hand pane in Power BI Desktop, click on either the grid icon (Data view) or the diagram icon (Model view).
2. Select the Column: Find your table in the 'Data' pane on the right side of the screen. Click on the column name you want to format (e.g., 'Sales Amount'). This will highlight the entire column in your data grid.
3. Use the 'Column tools' Tab: When you select a column, a new contextual tab called 'Column tools' appears in the top ribbon. Click on it.
4. Adjust the Formatting: In the 'Formatting' section of this ribbon, you will see several options:

For example, if you have a sales column with numbers like 450.9912 and 234.5000, selecting 'Currency' and typing '2' in the decimal places box will instantly reformat them to $450.99 and $234.50 across your entire report. It's that simple.

Formatting a Measure in the Report View

The process is nearly identical for measures, which are calculations you create using DAX. Since measures don’t exist as physical columns in your data model, you format them from the Report view.

1. Select the Measure: In the 'Data' pane on the right, find and click on the measure you want to format (it will have a small calculator icon next to it).
2. Go to the 'Measure tools' Tab: Just like with columns, selecting a measure will bring up the contextual 'Measure tools' tab in the top ribbon.
3. Apply Formatting: You’ll find the same 'Formatting' section here. Choose the format type (e.g., 'Percentage'), and then specify the number of decimal places (e.g., '1' to show percentages like 25.5%).

Method 2: Using DAX Functions for Precise Control

While the ribbon is great for simple, static formatting, sometimes you need more power and flexibility. This is where DAX (Data Analysis Expressions) comes in. By using DAX functions, you can create new calculated columns or measures that have exactly the formatting rules you define.

The primary function you'll use for this is FORMAT().

Heads up: The FORMAT function converts your number into a text string. This means you can't perform any further mathematical calculations on the output (like summing it up). Because of this, it's best to use FORMAT as the very last step in your DAX formula, specifically for display purposes in tables or cards.

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

The FORMAT Function Explained

The syntax for the function is straightforward:

FORMAT(<value>, <format_string>)

• <value> is the number or the measure you want to format (e.g., SUM(Sales[SalesAmount])).
• <format_string> is a special text code that tells Power BI how to display the number.

Here are some of the most common format strings you'll use to control decimal places:

The difference between a '0' and a '#' in format strings is subtle but important. A '0' is a digit placeholder that will display a zero if the position is empty. A '#' is a digit placeholder that displays nothing if the position is empty. For fixed decimal places, always use '0' after the decimal point to ensure they show up even if the value is a whole number (e.g., 50.00).

Example: Creating a Formatted Sales Measure

Imagine you have a basic measure for total sales:

Total Sales = SUM(FactSales[Amount])

You want to display this in a card visual but without any cents. You would create a new measure specifically for this display purpose:

Total Sales (Display) = FORMAT([Total Sales], "$#,##0")

Now you can use this new measure in your visual, and the number will always be formatted correctly as a clean currency amount, like $453,982.

A More Advanced Case: Dynamic Decimal Places

Here's where DAX really shines. What if you want to show two decimal places for small amounts (under $1,000) but no decimals for larger amounts? You can't do that with the ribbon, but you can with an IF statement in DAX.

Dynamic Sales Format =
IF (
    [Total Sales] < 1000,
    FORMAT ( [Total Sales], "$#,##0.00" ), // Format with two decimals for values under 1000
    FORMAT ( [Total Sales], "$#,##0" ) // Format with zero decimals for values 1000 or greater
)

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

Rounding vs. Formatting: What's the Difference?

It's crucial to understand the distinction between changing the display format and changing the actual value.

• Formatting (Using Ribbon or FORMAT): This changes only how the number looks. The underlying value remains precise. If you format 4.578 to show one decimal place, it will display as 4.6, but if you use it in another calculation, Power BI will use the full 4.578.
• Rounding (Using DAX functions like ROUND, ROUNDUP, ROUNDDOWN): This permanently changes the number itself to a specific number of decimal places. ROUND(4.578, 2) actually returns the value 4.58. All future calculations will use this new, rounded value.

In most cases, you just want to change the format for display. Only use rounding functions when you have a specific business requirement to alter the underlying data value.

Best Practices for Number Formatting

As you get comfortable changing decimal places, keep these simple rules in mind to maintain high-quality reports.

1. Be Consistent: If you show dollar amounts with two decimal places on one page, show them with two decimal places everywhere. Consistency prevents confusion and makes reports look polished.
2. Know Your Audience: An executive dashboard should favor simplicity - think whole numbers or summarizations like $1.5M. A financial deep-dive for an analyst team requires precision, so keeping the cents is important. Tailor your formatting to who is reading the report.
3. Use Centralized Formatting: Whenever possible, set the format for columns and base measures using the Ribbon method. This creates a default format that propagates everywhere, reducing the need for one-off DAX formatting in every visual.
4. Use FORMAT Sparingly: Reserve the FORMAT() function for final display visuals like cards, KPI text boxes, and tables where you need special formatting. Avoid using it in measures that will be used in further calculations, since it converts the number to text and breaks math operations.

Final Thoughts

Mastering how to change decimal places is a small but powerful skill that elevates the quality and clarity of your Power BI reports. By using the simple Ribbon tools for most of your needs and dipping into DAX functions like FORMAT for more complex requirements, you can ensure your data is always presented in the most readable and professional way possible.

Manually adjusting formatting for every table, clicking through ribbons, and writing DAX can quickly become time-consuming, especially when managing large reports. That’s why we built Graphed . Instead of hunting through menus, you can simply ask in plain English: "Show me total sales by product category as a table, with sales formatted as a currency with zero decimal places." We connect your data sources and translate your simple requests into perfectly built and formatted dashboards, turning hours of configuration into a 30-second task.