Forum Discussion

Aspi's avatar
Aspi
Helper I
5 years ago
Solved

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.

Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi Aspi 

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

    Regards

    Phil

4 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    5 years ago

    Hi Aspi 

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

    Regards

    Phil

    • Aspi's avatar
      Aspi
      Helper I
      5 years ago

      Hi Phil,

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Aspi 

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

     

    • Aspi's avatar
      Aspi
      Helper I
      5 years ago

      Hi Pranit,

      As I said in my first post iteslf, have tried doing that but doesnt work..

      Thanks