Forum Discussion
Helper IVhow to keep the two decimal digits after export data
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
Super UserHi 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