how to keep the two decimal digits after export data

[oakfootballclub]

for example, "0.00" in power bi is OK but when exported to excel it been "0", how can I make it '0.00' automatically when exported?

[Ritaf1983 · Accepted solution]

Hi @oakfootballclub 
To get the number with format 0.00 when exporting to Excel you can apply the steps :

1. From PQ modify the columns that are measured based on a "fixed number"

2. if it is a column then in data view change the format to a decimal number:

if you are creating a measure, you'll need to change the format of the measure in the same way (to avoid it in currency format because of "fixed")

3. you can publish and export in "current layout" which will give you the format with 00

the pbix is attached, you can follow my steps

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