Export In Excel

Hey SudhanshuD4512 ,

Power BI will export the underlying raw values when exporting the data and will not respect the visual formatting that you have maintained in the report.

If you want to export the exact values that you see in the report, you will need to convert the measure to text values. You can use the FORMAT function with suitable formatting text for it. 
Amount (Formatted) = FORMAT([Amount], "#,##0.00")
The "#,##0.00" will change as per your formatting need.
Now this approach will hinder your ability to use the measure for calculation but if you don't need totals or subtotals for the measure in the table visual you are exporting, it won't matter. (If you need it for calculation elsewhere, maintain two measures, one for calculation and other for display).

Hope it helps!

Hi SudhanshuD4512 

This is expected Power BI + Excel behavior, and unfortunately it’s not a bug, it’s how Excel handles numeric exports.

Why this happens is

-Power BI exports raw numeric values
-Measure formatting is visual-only
-Excel automatically:
>Drops trailing zeros (275.00 → 275)
>Ignores Power BI’s display formatting
-Even “Export with current layout” does NOT preserve numeric formatting

Power BI cannot force Excel to keep decimal formatting for numbers.

Convert the Measure to Text
If format matters more than calculations in Excel:

Formatted Amount =
FORMAT ( [Amount], "0.00" )

> Exports exactly as 275.00
> Becomes text (not numeric in Excel)

Please give headsup if it is correct approach, it might help other members as a solution. Thank You!