How to preserve decimal place digits when Exporting a table as CSV

[gmiralmasi]

Hi,

I am trying to export a table as a CSV file but the values decimals are not exported . Forexample the table value is 123456.88 but in CSV file it shows as 123456.00.

Is there a way to  to preserve decimal place digits when Exporting a table as CSV ?

Thanks

[Steve_H]

Just to make this a bit clearer for everyone, because it took me a little while to understand.  v-yingjl's response is correct.  In the export action itself, you cannot specify any formatting changes.  However, for a table you can independently change the number of decimal places in how a number is DISPLAYED, and in how it is EXPORTED.  

To change the number of decimal places DISPLAYED in a table, select on the table, then go: Format your visual

 > Visual > Specific column > Apply settings to (Series: select the column of interest) > Values > Value decimal places: 3 (or whatever you want).

To change the number of decimal places EXPORTED from a table, go: Select on that field in the Fields menu > Change the Formatting in the bar that appears at the top.

[v-yingjl]

Hello @gmiralmasi ,

When exporting data as a . CSV file, you cannot keep decimal digits directly. However, you can change the number of decimal places that are displayed for this value. For example, when the data is like 123457.78 in the underlying data, you can change decimal places as 0 to display is like 123457 to export as a . Csv. One disadvantage is that you will need a rounding approach.

For more information about export data, you can refer to the following Microsoft document:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data

Best regards

Yingjie Li

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

[amitchandak]

Please make sure you have set correct data format and it not overwritten on visual. Or correct data format in visual is there. In case of % 91 will be .91