Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Aspi
Helper I
Helper I

Numbers not being displayed same as in Excel.

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.Excel shows 3 digits.jpgPower BI shows only 1 digit.jpg

1 ACCEPTED SOLUTION
PhilipTreacy
Super User
Super User

Hi @Aspi 

Set the Column to Whole Number and set the Format to 000.  Just type 000 into the Format String Area.

cust-form.png

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

4 REPLIES 4
PhilipTreacy
Super User
Super User

Hi @Aspi 

Set the Column to Whole Number and set the Format to 000.  Just type 000 into the Format String Area.

cust-form.png

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Hi Phil,

Thanks for the advise. It has worked perfectly... Great.

pranit828
Community Champion
Community Champion

Hi @Aspi 

Change the format of this column in Power BI from number to text.

pranit828_0-1611267933608.png

 





PBI_SuperUser_Rank@1x.png


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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.