Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello all you experts,
I have data in Excel that has a number field with 3 digits i.e. leading zeros when . When uploaded into Power BI this field shows with only 1 digit. For example If Excel has 000 Power BI displays it as only 0. When Excel has 014 Power BI displays as only 14.
I would like to see all 3 digits being dislayed in my Dashboard...see screenshost attached.
Can someone pls advise a simple DAX formula to fix this issue??
I have tried changing the formatting in Power BI as Text and numbers but nothing works.
Regards.
Aspi.
Solved! Go to Solution.
Hi @Aspi
Set the Column to Whole Number and set the Format to 000. Just type 000 into the Format String Area.
Regards
Phil
Proud to be a Super User!
Hi @Aspi
Set the Column to Whole Number and set the Format to 000. Just type 000 into the Format String Area.
Regards
Phil
Proud to be a Super User!
Hi Phil,
Thanks for the advise. It has worked perfectly... Great.
Hi Pranit,
As I said in my first post iteslf, have tried doing that but doesnt work..
Thanks
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 38 | |
| 37 | |
| 28 | |
| 28 |
| User | Count |
|---|---|
| 124 | |
| 89 | |
| 73 | |
| 66 | |
| 65 |