CSV Export showing only to 1 decimal place when my table in Power BI is showing 3

[CathalSheehan]

Hi,

I hope this is a really simple solution. I need and have my table in Power BI showing to 3 decimal places. When I go to export the data and then open the CSV it is only showing to 1 decimal place. Can you tell me why this is the case and I what I need to do to ensure I export to 3 decimal places?

Thanks 

Cathal

[v-yingjl]

Hi @CathalSheehan ,

1. Choose a blank column in excel, open the .CSV file from text in Data ribbon
2. Click next to step3 directly
3. Change the data format into text and finish it
4. You may get the hoped result

Best Regards,
Yingjie Li

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

[amitchandak · Accepted solution]

@CathalSheehan , Change decimal place for that column/measure. Make it 3