Master Currency & Percentage Formatting in Power BI Visuals for Consistent, Polished Dashboards

Power BI handles number formatting very differently from Excel. Instead of right-clicking a cell and choosing Format Cells, you apply formatting through the Data view or the Modeling tab, which then consistently affects all visuals using that field or measure. Proper formatting makes Power BI visuals more interactive and gives them a clean, polished look.

In this tutorial, we will show how to format currency and percentages in a Power BI visual.

Why Formatting Feels Different from Excel

In Excel, you can click a cell and change its display format directly. In Power BI, you format a field or a measure, and that format applies everywhere that field is used across your entire report. This is more powerful because you set it once and it works consistently in every chart, table, and card.

You can format sales as currency and margins or growth rates as percentages. This ensures consistent number formatting across multiple visuals.

In most cases, you should format the underlying field or measure, not each visual individually. Power BI also supports more advanced custom format strings when the built-in options are not enough.

Formatting Currency in Power BI

Currency formatting adds a symbol ($, €, £, etc.), thousands separators, and controls decimal places. Apply it once in the model, and all visuals update automatically.

Steps:

• Open your Power BI Desktop file
• Go to the Data view (left sidebar icon that looks like a table)

• In the Fields pane (right side), click the column or measure you want to format
  • If it’s a regular column, the Column tools tab appears in the ribbon
  • If it’s a measure (calculated), the Measure tools tab appears
• Select the Sales Amount column
• The Column tools tab appears on the top ribbon
• Expand the Format dropdown >> select Currency

• Once Currency is selected:
  • A $ symbol button appears (or your locale’s default)
  • Click the Currency Symbol ($) dropdown to choose your preferred symbol ($, €, £, ¥, etc.)

• Use the Decimal places up/down arrows (usually starting at 2) to set 0, 1, 2, etc.
• The thousands separator (comma) is applied automatically

• Switch to the Report view >> place the field in any visual (card, table, bar chart, etc.)
• The currency symbol, commas, and decimals appear consistently

Common Gotcha: If a visual still doesn’t show the currency symbol, ensure Display units is set to None in the visual’s format pane (especially in newer card visuals).

Formatting Percentages in Power BI

Percentages can be tricky because Power BI expects the underlying value to be a decimal (0.756 = 75.6%). The % formatting multiplies the display by 100 and adds the % sign.

Steps:

• Go to the Data view (left sidebar icon that looks like a table)
• Select the column or measure in the Fields pane
• Select the Discount column >> expand the Format dropdown >> select Percentage

Measures:

• Select a measure column
• The Measure tools tab appears in the top ribbon
  • Click the % button in the Formatting section (it usually looks like a percent icon)
  • Or expand the Format dropdown >> select Percentage
• Adjust Decimal places (0 for whole numbers like 75%, 1 for 75.6%, 2 for 75.62%)
  • Power BI automatically multiplies the display value by 100

• Go back to the Report view; the Profit margin now shows a percentage symbol in the card

Important Notes: If your raw data is already in the form 75, 82, etc. (not 0.75, 0.82), do not format it as a percentage; it would show 7,500%. In that case:

• Create a measure: Correct % = DIVIDE([Your Number], 100)
• Or adjust the values in the Power Query Editor
• Then format that measure as a percentage
• You can also use a custom format string like 0.00″%”, which adds the symbol without multiplying

If your measure is already a rate, such as Conversion Rate = DIVIDE([Sales], [Visits]) that returns 0.124, apply Percentage formatting directly, and it will display as 12.4%.

Visual-Specific Percentage Options

You can apply a specific percentage format in table or matrix visuals.

• Select the visual
• Go to the Values field >> expand the dropdown
• Select Show value as >> choose Percent of grand total, Percent of row total, or Percent of column total

• This displays percentages of totals without changing the underlying measure format

After applying currency and percentage formats in the Data view, the entire report updates automatically with proper symbols.

Using Custom Format Strings for Advanced Control

For precise control, Power BI supports Excel-style custom format strings.

• Select your column or measure
• Go to the Column tools or Measure tools tab
• Type the string into the Format box and press Enter
• The preview updates immediately

Best Practices

Use these habits to avoid formatting problems later:

• Set the correct data type first
• Format measures immediately after creating them
• Keep currency symbols consistent across the report
• Store percentage values as decimals in the model
• Use custom format strings only when built-in formats are not sufficient
• Refresh visuals after changing formats (occasionally required)

Conclusion

By following the steps above, you can format currency and percentages in Power BI visuals efficiently. Formatting currency and percentages is primarily a modeling task, not a visual cell-formatting task like in Excel. Select the field, ensure it has the correct numeric data type, and then set its format to Currency or Percentage from the modeling tools. Once applied, your visuals update automatically and remain consistent across the report. This approach ensures your Power BI reports display clean, professional currency and percentage values with better scalability.