Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |