Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 @Aspi
Change the format of this column in Power BI from number to text.
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
Hi Pranit,
As I said in my first post iteslf, have tried doing that but doesnt work..
Thanks
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |