Rounding disappearing on export to Excel

[user131313]

Hi,

I've got a table of data that is rounded to 2 decimal places in my report. I want it to be available to export via the elipses with only 2 decimal places appearing in the rounded fields on export. However the data appears in Excel without the rounding, with a huge number of decimal places. I've tried export via all three of the options: Data with current layout, Summarized data and Underlying data and in all three cases the data exported is not rounded as it is within the report itself.

I don't want to apply Number.Round or anything to the fields as I only want to round the total summed data in the report, not each individual record as otherwise I lose a lot of accuracy in the totals calculated.

Is there any solution to this?

Thank you!

[v-chenwuz-msft]

Hi @user131313 ,

Maybe you can use Enhanced Data Culture with Connected PivotTables in Excel for the web.

https://powerbi.microsoft.com/en-us/blog/enhanced-decision-making-with-connected-pivottables-and-imp... 

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Create a measure with the appropriate rounding.  Then use that measure instead of the original value in your visual.