Forum Discussion
how to keep the two decimal digits after export data
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?
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
1 Reply
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