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
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
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
