How to Change Units in Power BI

Nothing sours a perfect Power BI report faster than incorrect data units. You’ve cleaned your data and built your visuals, but your sales card shows "$534K" instead of the exact "$534,281" your boss needs to see. This article will show you exactly how to take control and change the display units in Power BI, from a quick fix on one chart to setting report-wide standards.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Power BI Uses Automatic Units

Before diving into the "how," it's helpful to understand the "why." By default, Power BI tries to be helpful by automatically scaling large numbers to make them more readable at a glance. It converts values in the thousands to "K," millions to "M," and billions to "B." This is part of Power BI's "Auto" display unit feature.

For high-level dashboards where stakeholders just need a quick overview, this is great. A chart comparing sales across different regions is often easier to interpret with labels like $1.2M, $2.5M, and $950K than with $1,200,000, $2,500,000, and $950,000. It reduces visual clutter.

However, this helpful feature can become a headache when:

• Precision is required: For financial reporting, budget tracking, or detailed sales analysis, the exact numbers are non-negotiable.
• Consistency is lacking: Sometimes a dashboard might show one visual in thousands (K) and another in millions (M), which can be confusing for your audience.
• The scale is too small: The auto-scaling doesn't add much value for numbers that are only in the hundreds or low thousands and can sometimes feel unnecessary.

Fortunately, you have complete control over this behavior. Let's walk through the different methods you can use.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 1: The Visualizations Pane (The Quick, Chart-by-Chart Fix)

This is the most common and direct way to change units for a single, specific visual. If you only need to adjust one card, bar chart, or graph, this is your go-to method.

Let's say you have a Card visual showing "Total Revenue," and Power BI has formatted it to "$1.4M." Here’s how to change it back to the full number.

Step-by-Step Instructions

1. Select the Visual: Click on the card, chart, or table you want to modify in your Power BI report.
2. Open the Format Pane: On the right side of the screen, find the "Visualizations" pane. Click the paintbrush icon labeled "Format your visual" to open the formatting options.
3. Find the Display Units Option: The location of the "Display units" setting depends on the type of visual you've selected.
4. Choose Your Desired Unit: Click the "Display units" dropdown. You'll see a list of options:

By selecting "None," your "$1.4M" will instantly change to "$1,420,530" within that specific visual, giving you the precision you need without affecting any other charts in your report.

Method 2: The Modeling Ribbon (The Column-Level Fix)

Changing the settings for every single visual can be tedious, especially in a report with many charts. If you want to set a default format for a specific field or column across your entire report, the Modeling ribbon is the way to go.

This method adjusts the metadata for a column in your data model. Once you set it, any new visual you create with that column will automatically use the format you specified, saving you time and ensuring consistency.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step-by-Step Instructions

1. Go to Data or Model View: In the left-hand navigation bar, click on either the "Data view" (the grid icon) or "Model view" (the diagram icon).
2. Select the Column: In the "Data" pane on the right, find the table containing your desired field and click on the column name (e.g., 'SalesAmount'). The column itself will be highlighted in the data view grid.
3. Use the "Column Tools" Ribbon: Once a column is selected, a new contextual ribbon called "Column tools" will appear at the top of the window.
4. Apply Formatting: In the "Formatting" section of this ribbon, you will see several options:

After you apply these settings, go back to your "Report view." Any visuals using this column (including any new ones you create) will now respect this formatting by default. It’s a powerful way to enforce consistency across your reports.

Method 3: Custom Formats with DAX (for Ultimate Flexibility)

What if you need a format that's not available in the standard menus? Maybe you want to add text, enforce a specific non-standard number format, or create dynamic units based on the value. For this level of control, you'll need to turn to Data Analysis Expressions (DAX).

The main DAX function for this is FORMAT, which allows you to convert a value to a text string with a specific format code.

Heads Up: A very important thing to know is that the FORMAT function turns your number into text. This means you can't use the new measure in other calculations or for automatic sorting by value. It's best used for final display purposes in cards, tables, and tooltips.

Let's say you want to format a "Total Sales" measure.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step-by-Step Instructions

1. Create a New Measure: Right-click on your table in the "Data" pane and select "New measure."
2. Write the DAX Formula: In the formula bar, use the FORMAT function.
3. Use Your New Measure: Drag this newly created DAX measure into your visuals instead of the original measure. It will appear pre-formatted exactly as you defined.

Using DAX offers near-limitless control, but it requires more effort and a good understanding of its limitations, especially the number-to-text conversion.

Choosing the Right Method

With three different ways to change units, how do you know which one to pick?

• Use the Visualizations Pane when you have a one-off adjustment to make in a single chart and don't want it to affect any other visual. It’s fast and local.
• Use the Modeling Ribbon when you want to establish a standard, report-wide format for a column. It’s the best practice for promoting data model consistency.
• Use DAX Formatting when you need a custom format that the menus don't provide or want to create dynamic text-based outputs. It's the most powerful but also the most complex.

Final Thoughts

Mastering how to display units in Power BI is a fundamental step toward building clear and professional reports. You can either make a quick adjustment to a single visual, set a report-wide default for a data column, or write a custom DAX measure for total control. Choosing the right method will help you deliver precise and easily understandable insights every time.

While mastering tools like Power BI is incredibly rewarding, the process of connecting data, writing formulas, and tweaking settings can still consume a lot of time. That's why we built Graphed . We simplify the entire reporting process by letting you use natural language. Instead of clicking through menus, you can just ask, "Show me a dashboard of monthly sales with the full number value," and it builds it for you, connected directly to your live data. This helps you get straight to the insights, cutting down hours of manual configuration.