How to Put Comma in Numbers in Power BI

Nothing sours a beautiful dashboard faster than poorly formatted numbers. Seeing a long string of digits like 14839274 forces your audience to count the places just to figure out what they're looking at. Adding standard thousand separators, or commas, is a small touch that makes your reports instantly more professional and much easier to read. In Power BI, getting those commas in place is simple, and this guide will show you a few different ways to do it.

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 walk you through the three best methods for adding commas to your numbers in Power BI, from a simple button click to a more flexible formula-based approach.

Good Formatting Is Good Communication

Before jumping into the "how," it's worth a quick reminder of the "why." Proper number formatting isn't just about making things look nice, it’s about clear communication. Your goal with any report or dashboard is to convey information quickly and accurately.

Consider the difference:

• 5893410.75
• 5,893,410.75

The second number is immediately recognizable as "almost 5.9 million." With the first, you have to mentally pause and parse the digits. When your stakeholders are flipping through a report, that small pause adds up, creating friction and opportunities for misinterpretation. Simply adding a comma separator removes this friction, making your data more accessible and professional.

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 1: The One-Click Comma in Column Tools

This is the fastest and most common way to format an entire column of numbers in Power BI. When you apply this format, it applies everywhere that column is used throughout your report, which keeps your visuals consistent.

Follow these quick steps:

1. Go to the Data View: On the left-hand navigation pane in Power BI Desktop, click on the icon that looks like a spreadsheet table. This is the Data View, where you can see your raw data tables.
2. Select Your Column: Find and click on the header of the numeric column you want to format (e.g., 'Sales', 'Revenue', 'Page Views').
3. Use the Column Tools Ribbon: Once you select a column, a new contextual tab called Column tools will appear in the top ribbon.
4. Click the Comma: In the 'Formatting' section of the Column tools ribbon, you will see a large comma icon. This is the Thousand Separator. Click it.

That's it! Power BI will immediately apply the comma to every number in that column. You’ll notice it also automatically adds two decimal places. If you don't need them, you can adjust the number of decimal places right next to the comma button.

This method is perfect for formatting columns imported directly from your data source.

Method 2: Formatting in the Model View

The Model View is primarily used for managing relationships between your data tables. However, it also includes a robust Properties pane that allows you to format multiple columns quickly without having to click on each one individually in the Data View.

This approach achieves the same result as the first method, but can be more efficient if you're already organizing your data model.

1. Go to the Model View: On the left-hand navigation pane, click the icon that represents table relationships (it looks like three connected boxes).
2. Select Your Column: Find the table containing your desired column. Click on the column name in the table card to select it.
3. Use the Properties Pane: On the right side of the screen, ensure the Properties pane is visible. If it isn't, go to the 'View' tab and check the 'Properties' box.
4. Apply Formatting: In the Properties pane, scroll down to the 'Formatting' section. You will see an option for 'Thousand separator'. Simply switch this toggle to On.

Like the first method, this will also default to two decimal places, which you can adjust in the same section of the Properties pane. This is a great workflow for BI developers who spend a lot of time defining their data model and want to set formats at the same time.

Method 3: Using DAX for Custom Formatting (Measures and Calculated Columns)

Sometimes the one-click methods aren't quite enough. You might be creating a measure, or you might need a format that changes based on certain conditions. In these cases, you can turn to DAX (Data Analysis Expressions), Power BI’s formula language. The key function here is FORMAT.

The FORMAT function converts a value to text with a specified format.

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

When to Use DAX for Formatting

• When creating a new measure instead of formatting an existing column.
• When you need to combine a number with text (e.g., "Revenue: $1,234,567").
• When you want complete control over how numbers, decimals, and currency symbols appear.

Important Note: When you use the FORMAT function, the output is no longer a number, it becomes a text string. This means you can't perform any further mathematical calculations on it (like summing or averaging). The best practice is to create a cleanly formatted measure for display purposes, but keep your original, unformatted numeric measure for any calculations.

Example 1: Basic Comma Separator in a Measure

Imagine you have a base measure to calculate total sales: Total Sales = SUM(Sales[Revenue]). To create a formatted version for display, you would create a new measure:

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

Let's break down the format string "#,##0":

• The # is a digit placeholder that only shows digits when they exist.
• The , tells Power BI to insert a thousand separator.
• The 0 is also a digit placeholder, but it will display a '0' even if the number is zero.

Example 2: Adding Decimal Places

If you want to ensure your number always shows two decimal places, you can adjust the format string:

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

Example 3: Including a Currency Symbol

You can also insert symbols like the dollar sign directly into the format string:

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

Using DAX offers incredible flexibility, allowing you to build dynamic and highly customized labels and card visuals in your reports.

Troubleshooting Common Formatting Issues

Things don't always go as planned. Here are a couple of common issues you might encounter and how to fix them.

The Comma Button is Grayed Out

If you select a column and the comma button in the Column Tools ribbon is disabled, it's almost always because Power BI doesn't recognize the column as a numeric data type. It might be set to 'Text'.

Solution: With the column selected, look in the 'Formatting' section of the Column Tools ribbon. There is a 'Data type' dropdown. Change it from 'Text' to a numeric type, such as 'Whole number' or 'Decimal number'. The comma button should then become active.

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

My DAX-Formatted Measure Won't Sum Up

This goes back to the important note above. The FORMAT function outputs text. If you try to put a measure like [Formatted Total Sales] into a chart that requires aggregation (like a bar chart's value field), it won't work correctly because you cannot sum up a text string.

Solution: Always use two separate measures. Use the clean, numeric measure (e.g., [Total Sales]) for your chart axes and values. Use the text-formatted version (e.g., [Formatted Total Sales]) only in visuals where text is appropriate, such as a card visual, a table cell, or in a tooltip.

Final Thoughts

Adding comma separators is a fundamental step in making your Power BI reports clean, professional, and easy to understand. Whether you prefer the quick click in the ribbon or the powerful control of a DAX formula, formatting your numbers correctly will significantly improve the user experience for anyone consuming your data.

Building clear, effective dashboards shouldn't be a tedious process bogged down by clicks and manual configurations. At Graphed, we’ve completely automated the report-building process by allowing you to create entire dashboards with natural language. You connect your data sources like Google Analytics, Shopify, or Salesforce and simply ask for what you want to see - "Show me a dashboard of my marketing funnel conversion rates this quarter" - and the dashboard is built for you in seconds, with everything appropriately formatted, so you can spend less time configuring and more time analyzing.