How to Add Thousand Separator in Power BI

Seeing a long string of numbers like 19574342 in a report is more than just an eyesore - it’s an opportunity for misinterpretation. Adding thousand separators, like commas, instantly makes large figures readable and professional. This article will walk you through the simple, built-in GUI methods for adding thousand separators in Power BI, as well as a more flexible DAX approach for custom formatting.

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 Number Formatting Matter?

Before jumping into the "how," it's worth taking a moment to understand the "why." Proper number formatting is a small detail that has a big impact on the quality and usability of your dashboards. Here’s why it’s so important:

• Improved Readability: This is the most obvious benefit. The human brain processes grouped numbers far more easily than long, unbroken strings. Comparing 12345678 and 12,345,678 makes it clear which one you can interpret at a glance. When a stakeholder is looking at your dashboard, you want them to absorb the information instantly, not spend time counting digits.
• Reduced Errors: When numbers are hard to read, mistakes happen. It’s easy to misread $1,000,000 as $100,000 if there are no commas. Proper formatting acts as a safeguard, ensuring the data is communicated accurately and reducing the chance of costly decisions based on a simple misreading.
• Professionalism and Credibility: A well-formatted report shows attention to detail. It signals to your audience - whether it's your manager, a client, or a board member - that the report is polished, professional, and trustworthy. Sloppy formatting can subconsciously erode confidence in the data itself.

In short, taking a few seconds to add thousand separators is a foundational step in building effective and clean data visualizations that people can actually use.

Method 1: The Quickest Way Using the Modeling Ribbon

For most day-to-day use, this is the fastest and most common method. Power BI provides a one-click button to apply standard thousand separators to any numeric column or measure. This method formats the number directly where it's used.

Follow these simple steps:

1. Select a field to format. In the Power BI report view, navigate to the Fields pane on the right side of your screen. Click on the measure or column you want to format. For example, you might select a [Total Revenue] measure.
2. Open the Tool Tab. Once you select a field, a contextual tab will appear in the top ribbon. If you've selected a column, you'll see the Column tools tab. If you've selected a measure, the Measure tools tab will appear.
3. Apply the Thousand Separator. In the "Formatting" section of the ribbon, you will see a comma icon (,). This is the thousand separator button. Click it.

That's it! Every visual in your report that uses this field will now display the number with thousand separators. For example, 1234567 will automatically become 1,234,567.00.

You can also control the number of decimal places from this same "Formatting" section in the ribbon. Simply change the number in the box next to the comma icon to a 0 if you only want to show whole numbers.

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: Formatting in the Data View for Consistency

What if you want to set the format for a column once and have it apply everywhere by default, right from the source? The Data view is the perfect place for this. This tells Power BI how a specific column should be treated for the entire lifetime of the report, ensuring consistency without having to format it again.

Here’s how you do it:

1. Switch to the Data View. On the left-hand side of the Power BI interface, click on the icon that looks like a spreadsheet table. This will take you into the Data view.
2. Select Your Column. In the Fields pane on the right, find and click on the numeric column you want to format. The data for that column will be highlighted in the main window.
3. Use the Column Tools Ribbon. Just like in the Report view, selecting the column will bring up the Column tools tab in the top ribbon.
4. Click the Comma. Head to the "Formatting" section and click the comma icon (,).

By setting the format here, you establish a default for that column. Now, any time you drag this column into a new table, card, or chart, it will automatically include the thousand separator. This is a best practice for keeping your data model clean and your reports consistent.

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

Method 3: Using a DAX FORMAT Function for Custom Control

Sometimes the standard formatting options aren't enough. You might want to combine numbers with text, enforce a specific currency symbol, or format a number differently based on a certain condition. For this level of control, you need to use DAX (Data Analysis Expressions).

The FORMAT function in DAX lets you convert a value into a text string using a specified format.

The basic syntax is:

FORMAT(<value>, <format_string>)

To use it for adding a thousand separator, you'd typically create a new measure. For instance, if you already have a measure like Total Sales = SUM(Sales[Amount]), you could create a new formatted measure:

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

Here’s what common format strings mean:

• "#,##0": This is the standard. It adds a comma as a thousand separator and shows only whole numbers.
• "#,##0.00": This will add the comma and display the number with two decimal places.
• "$#,##0": This adds a dollar sign prefix, as well as the thousand separator.
• "€#,##0.00": This will add a euro symbol and include two decimal places.

The 0 is a placeholder that will display a digit or a zero, while # displays a digit or nothing. Using #,##0 ensures that a value of zero still shows up as "0".

Important Warning: FORMAT Turns Numbers into Text!

This is the most critical thing to understand when using the FORMAT function. It changes the data type of your value from a number to a text string.

This has two major consequences:

1. You can't perform further calculations. Once a number is converted to text, you can no longer use it in mathematical aggregations like SUM, AVERAGE, MIN, or MAX. For example, an AVERAGE of text values like "$1,234" is meaningless.
2. Sorting might behave unexpectedly. Visuals will sort text values alphabetically, not numerically. This means a list might sort like this: "$10,500", "$2,100", "$500". This is rarely the desired behavior.

For these reasons, the best practice is to always use the formatting options in the Modeling ribbon (Methods 1 and 2) whenever possible. Use the FORMAT function only when absolutely necessary, such as for specific card visuals or table columns where the value is final and doesn't need to be sorted or aggregated further.

Troubleshooting Common Formatting Issues

Running into problems? Here are a couple of the most common issues and how to fix them.

The Comma Button is Greyed Out

If you've selected a column and the thousand separator button is disabled, it's almost always because Power BI doesn't recognize the data as a number. Even if the column looks like it contains only numbers, it might be set to a "Text" data type.

The Fix: Change the data type.

• You can do this in the Column tools ribbon (from the Data or Report view) by using the "Data type" dropdown and selecting "Whole Number" or "Decimal Number."
• The most robust way is to go into the Power Query Editor (click Transform data on the Home ribbon). Select the problematic column, and on the "Transform" tab, change the Data Type. After you "Close & Apply," you’ll be able to format the column as a number.

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 Formatting is Different Across Visuals

If a number is formatted in one chart but not another, it usually means that a specific visual has an overriding format setting. Select the visual, go to the Format visual pane (the paintbrush icon), and check the settings under "Values" or "Data labels" to see if a custom format has been applied there.

Final Thoughts

Formatting numbers with thousand separators is a fundamental yet powerful step toward creating reports that are not only accurate but also clear, intuitive, and professional. Whether you use the simple one-click comma button in the ribbon or the more customizable DAX FORMAT function, cleaner visuals are always just a couple of clicks away.

While mastering tools like Power BI is incredibly valuable, the reality is that much of the time spent on reporting is manual clicking, data wrangling, and formatting. We built Graphed because we wanted to automate that entire process. Instead of navigating menus, you can connect your data sources directly and just ask for what you need in plain English - like "Show me total revenue versus marketing spend by campaign for the last 90 days." Graphed instantly builds the dashboard for you, with everything properly formatted and updating in real-time, turning hours of tedious work into a 30-second task.