Forum Discussion
Helper IHow to export unformatted data to excel
Hi,
I have a matrix with columns that are formatted as follows:
I like to export the unformatted data to excel. How can I do that?
Appreciate your help.
Raymond
Hi Raymo3u99 ,
You can create measure with format like:
measure = FORMAT(MAX('Table'[Column1]),"#.####")Then trying to export data from visual.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
6 Replies
- amitchandak
Super User
Raymo3u99 , from desktop when export the data to csv it should be unformatted
Also refer: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data
Raymo3u99The formatting convert the numeric column to text and so when I download to csv, I lose the decimal precision.
[Monthly Plan Variance] Curr Qtr FC Prior Qtr FC [Qtrly Variance]
(0.1) (24.7) (24.7) 0.0
0.3 (16.0) (16.0) 0.0
(1.2) (41.4) (41.4) 0.0
(2.3) 374.5 374.7 (0.2)
(0.3) 10.1 10.1 0.0
(0.1) 1.9 1.8 0.0
0.0 (2.9) (2.9) 0.0
0.0 (0.7) (0.7) 0.0
0.3 (20.7) (20.7) 0.0
(0.3) 0.0 0.0 0.0
Pardon my copy and paste.
Raymond
v-deddai1-msftCommunity Support
Hi Raymo3u99 ,
You can export underlying data from visuals in power bi https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data#export-underlying-data
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
