Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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.
Create a measure with the appropriate rounding. Then use that measure instead of the original value in your visual.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.