Export In Excel

[SudhanshuD4512]

I have a measure I have set its formatting as decimal number and kept round at 2 digits. Still When I am taking export from power bi service it gives all digit and dont retain the formatting, also it removes like if amount is 275.00 but in export it shows 275. It removes trailing zeroes by default in excel. 

[alish_b · Accepted solution]

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!

[v-veshwara-msft]

Hi @SudhanshuD4512 ,

Following up to see if your query is resolved and if any of the responses helped.
If you're still facing issues, feel free to reach out.

Thank you.

[v-veshwara-msft]

Hi @SudhanshuD4512 ,

Just checking in to see if you query is resolved and if any responses were helpful.
Otherwise, feel free to reach out for further assistance.

Thank you.

[v-veshwara-msft]

Hi @SudhanshuD4512 ,

Thanks for reaching out to the Microsoft Fabric Community.

As noted by others in this discussion, Power BI exports the underlying data by default, which does not retain the formatting applied in the report. However, when exporting, you can choose the Data with current layout option, which preserves the formatting as shown in the visual.

Please try exporting using this option and check whether the formatting is retained.

If you need any further assistance, feel free to reach out.
Thank you.

[krishnakanth240 · Accepted solution]

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!

[Zanqueta]

Hi @SudhanshuD4512 

Power BI exports the underlying dataset, not the formatted representation. The formatting (decimal places, currency symbols, trailing zeros) is part of the report layer, not the data layer.

Possible Solutions

1. Apply formatting in Excel after export

2. Use “Export with Current Layout” (if available)

• In some scenarios, using Export with Current Layout (from the visual options in Power BI Service) can preserve the layout and formatting closer to what you see in the report.
  However, this option is only available for certain visuals and does not always guarantee full formatting retention.

Official reference:

Export data from a Power BI visualization - Power BI | Microsoft Learn

If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.

Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.

[alish_b · Accepted solution]

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!

[AntoineW]

Hi , 

Solution 1 — Use FORMAT() (Best when formatting matters)

If presentation in export matters, convert the measure to text:

 

 

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

References : 

- https://learn.microsoft.com/fr-fr/dax/format-function-dax

Hope it can help you!

Best regards,

Antoine

@SudhanshuD4512