How to Format a Number in Power BI

Updated on:

May 12, 2026

By:

Use this interactive demo to learn how to apply number formatting in Power BI visuals.

Quick summary

Formatting numbers in Power BI lets you control how values appear in your visuals, turning raw decimals into percentages, currencies, or other meaningful formats. You can apply number formatting directly through the Format visual panel without writing any DAX or custom code.

Steps

Select your visual and navigate to the Format visual panel on the right side of your screen.
Click on the General section in the formatting options.
Expand the General menu and locate Data format to customize how your numbers appear.
Select the specific column you want to format from the available fields list.
Under Format options, click the dropdown and select Percentage to convert decimals into meaningful percentages.
Your numbers are now properly formatted and ready to display in your Power BI report.

📌 Why this matters

Properly formatted numbers are essential for making Power BI reports readable and actionable. Without correct number formatting, stakeholders may misinterpret raw decimals as absolute values instead of percentages or currencies, leading to poor business decisions. Power BI's built-in Format visual panel lets analysts apply number formatting in seconds — no DAX formulas or custom measures required. This makes it easy for both beginners and advanced users to ensure their data visualizations communicate clearly and professionally.

Your product deserves an interactive demo

Start free

How to Uninstall Power BI

How to Compare Two Measures in Power BI

How to Compare Months in Power BI