How to Add Commas in Power BI

Nothing makes a data table or chart harder to understand than a long string of unformatted numbers. When your stakeholder is trying to figure out if that number is 1.5 million or 15 million, you’ve already lost their attention. This article will show you several ways to add thousand comma separators in Power BI to make your reports clear, professional, and easy to read.

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 Correct Number Formatting Matters

Before we get into the "how," let's quickly touch on the "why." Proper formatting isn't just about making things look nice, it’s about clarity and credibility.

• Readability: The primary reason is to make large numbers easily digestible. Our brains can process 12,456,789 much faster than 12456789. This reduces the cognitive load on your audience, allowing them to focus on the insights, not on deciphering the numbers.
• Professionalism: Well-formatted reports signal attention to detail. It shows you care about the end-user experience, which builds trust in your data and your analysis.
• Consistency: Applying consistent formatting across all your visuals and reports creates a unified and predictable experience for your users, making it easier for them to navigate and understand your work.

Method 1: The Quickest Fix using the Formatting Ribbon

This is the most direct and common method for formatting numbers. You apply it directly to a specific field in the "Report" view. This works whether you are formatting a measure or a regular column.

Let's say you have a card visual showing total sales revenue as 4587321.55. Here's how to add a comma:

Step-by-Step Instructions:

1. Select Your Visual: Click on the visual in your report that contains the number you want to format (e.g., a card, a table, or a chart).
2. Select Your Field: In the "Data" pane on the right-hand side, make sure the field you want to format is selected. When you click on a field used in a visual, it will become highlighted in the Data pane.
3. Go to the "Column Tools" or "Measure Tools" Ribbon: With the field selected, a new contextual tab will appear in the main ribbon at the top of the Power BI window. If you selected a regular data column, you'll see "Column tools." If you selected a custom DAX measure, you'll see "Measure tools."
4. Click the Comma: In the "Formatting" section of this ribbon, you'll see a small comma icon (,). Click it.

Just like that, your number will be formatted with a thousand separator. The value 4587321.55 will now display as 4,587,321.55. That single click told Power BI to apply a standard number format with commas.

This method is excellent for quick, one-off formatting changes in a specific visual or for a measure you've just created.

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: Format the Column in the "Data" View for Consistency

While the first method is fast, you might have to repeat it for every new visual where you use that field. If you want the number formatting to be applied everywhere you use a specific column throughout your report, it's more efficient to format it at the source in the "Data" view.

This approach changes the default formatting for the column itself within your data model. Every time you drag that column into a new visual, it will already have the comma separator.

Step-by-Step Instructions:

1. Switch to the "Data" View: On the left side of your Power BI screen, click on the icon that looks like a spreadsheet table to enter the "Data" view.
2. Select Your Table and Column: From the "Data" pane on the far right, select the table, and then find and click on the specific column header in the main window that you want to format (e.g., the 'Revenue' column).
3. Use the "Column Tools" Ribbon: Just like in the Report view, clicking the column will bring up the "Column tools" tab in the top ribbon.
4. Apply Formatting: In the "Formatting" section, click the comma (,) icon. You can also use the dropdown menu next to "Format" to select other options like "Currency" or to adjust the number of decimal places.

Now, whenever you use this 'Revenue' column in any new table, matrix, chart, or card, it will automatically include the thousand separator by default. This is a best practice for key metrics, saving you time and ensuring your reports are consistent.

Method 3: Using the DAX FORMAT Function for Ultimate Control

Sometimes you need more granular control over how your number is displayed, especially inside other DAX measures. This is where the FORMAT function comes in handy. It allows you to convert a number into a text string with a specific format code.

Heads up: This is an incredibly powerful function, but it has one major catch. The FORMAT function turns your number into a text value. This means you can no longer perform mathematical calculations on the result. It's strictly for display purposes in places like tables, cards, or as a chart label.

The basic syntax is:

FORMAT(<value>, <format_string>)

Here are a few common examples of how you might use it to add commas.

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

Example 1: Basic Comma Formatting

To simply add a comma separator to a whole number like 'Total Units Sold':

Formatted Total Units = FORMAT(SUM('Sales'[UnitsSold]), "#,##0")

If the sum of Units Sold was 23456, this measure would return the text string "23,456". The 0 ensures that if the value were 0, it would display as '0' and not be blank.

Example 2: Adding Currency Symbols and Decimals

You can get more detailed, adding currency symbols and locking in decimal points.

Formatted Total Sales = FORMAT(SUM('Sales'[Revenue]), "$#,##0.00")

If the sum of Revenue was 1500450.758, this would return "$1,500,450.76". The format string rounds to two decimal places for you.

When to Use the DAX FORMAT Function

• When you need to display a specially formatted number inside a text-based result, like a dynamic title.
• When you want to combine numbers and text within a single column in a table or matrix.
• When visual-level formatting just isn't giving you the exact output you need.

When to AVOID the DAX FORMAT Function

• Never use it for measures that you need to plot on a chart axis (like a line chart or bar chart value axis). Since the result is text, the chart won't be able to sort or scale it correctly.
• Avoid using it for measures that you plan to use in other, subsequent calculations. Calculations on text values won't work and will return an error.

Rule of thumb: do all your calculations with unformatted numeric measures first. Only create a final, specially formatted version for a very specific display purpose, like in a table.

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

Bonus Tip: Understanding Regional Settings

Ever wonder why your comma shows up as a period, or vice versa? Power BI is heavily influenced by your computer's "regional settings."

• In the United States, the thousand separator is a comma (,) and the decimal separator is a period (.) — e.g., 1,234.56.
• In many parts of Europe, it's the opposite. The thousand separator is a period (.) and the decimal separator is a comma (,), — e.g., 1.234,56.

Power BI Desktop will typically default to your Windows regional settings. If your formatting isn't appearing as expected, this is often the culprit. You can either change your local machine's settings or, in some cases, change the model locale within Power BI by going to File > Options and settings > Options > Current File > Regional Settings.

Troubleshooting Common Formatting Issues

Here are a few pitfalls and how to fix them:

1. "My formatting isn't applying correctly." Check if you're formatting the correct field. Often, a table might use a base column (e.g., 'Sales Amount') while you have been trying to format a measure (e.g., 'Total Sales') that sounds similar. Double-check the fields being used in your visual.
2. "I used FORMAT and now my chart is broken." This is the classic data type issue. Your chart needs numbers to plot on an axis, but FORMAT turned your measure into text. Go back to your original, unformatted numeric measure and use that for the chart. Apply the comma format using Method 1 or 2 instead.
3. "The comma setting reset itself." If you're only formatting at the visual level (Method 1), that format only applies to that instance of the field. To make it permanent, use Method 2 and format the column in the Data View. That sets the default for any time you use that field.

Final Thoughts

Adding comma separators is a simple but effective step to make your Power BI reports much more user-friendly. Whether you use the quick formatting in the ribbon, set a permanent format in the Data View, or leverage the control of DAX, the key is to present clean and readable numbers so your audience can focus on the insights you've found.

Manually tweaking reports and getting the formatting just right is often where we spend most of our time - time that could be spent on strategy instead of dashboard design. At Graphed, we help you skip the manual busywork. You can connect all your marketing and sales data sources in seconds, then use plain English to describe the dashboard you need. Graphed automatically builds professional, real-time reports and dashboards for you, so you can stop wrestling with formatting and start getting answers.