How to export unformatted data to excel

[Raymo3u99]

Hi,

I have a matrix with columns that are formatted as follows: 

"##,##0.0;(##,##0.0);0.0"

I like to export the unformatted data to excel. How can I do that?

Appreciate your help.

Raymond

[amitchandak]

@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

[Raymo3u99]

@amitchandak 

The 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-msft]

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-underlyi...

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

[Raymo3u99]

@v-deddai1-msft, @amitchandak 

This did not work for me.

I'm trying to get the unformatted numbers into excel.

Here are three screen shots:

There screen shots are from the report, SQL and excel.

Please ignore the actual values as there are groupings withing the report (also showing in 1000's)  and SQL while  in excel they are at the lowest level.

I'm trying to get the 5 decimal into excel just as it exists on the database.

Thanks again for your help.

Raymond

[v-deddai1-msft · Accepted solution]

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

[Raymo3u99]

@v-deddai1-msft 

@amitchandak 

The requirement is to show just one decimal in the matrix. But it should export the raw data with 5 decimals.

Is that possible?

Thanks,

Raymond