Forum Discussion
Rounding disappearing on export to Excel
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!
2 Replies
- lbendlin
Super User
Create a measure with the appropriate rounding. Then use that measure instead of the original value in your visual.
- v-chenwuz-msft
Community Support
Hi user131313 ,
Maybe you can use Enhanced Data Culture with Connected PivotTables in Excel for the web.
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.
