Forum Discussion

NLEIGH's avatar
NLEIGH
Icon for Helper I rankHelper I
2 years ago
Solved

Decimal place not working

Hi,

Iam having troble getting Power BI to show a decimal place correctly, i've imported a simple file and it shows the decimal place correctly for holiday 2.5 (see screenshot below), however when I try to pull this data into a Table it shows as a "3" rather than 2.5.

 

I'd be grateful if anyone can help.

Many thanks,

 

Need Help
  • zenisekd's avatar
    zenisekd
    2 years ago

    Change the Type from Whole number to Decimal number. 🙂


    Kudos and mark as solution appreciated 🙂

     

4 Replies

  • zenisekd's avatar
    zenisekd
    Icon for Super User rankSuper User
    2 years ago

    Hi NLEIGH , when in Power BI select the column in Data list you are interested in and adjust the displayed decimal places. 



    Kudos and mark as solution appreciated.

    • zenisekd's avatar
      zenisekd
      Icon for Super User rankSuper User
      2 years ago

      Change the Type from Whole number to Decimal number. 🙂


      Kudos and mark as solution appreciated 🙂

       

    • NLEIGH's avatar
      NLEIGH
      Icon for Helper I rankHelper I
      2 years ago

      Hi, Thanks but I had already done that, please see below, but still not showing as 2.5 !

       

       

      • NLEIGH's avatar
        NLEIGH
        Icon for Helper I rankHelper I
        2 years ago

        Great thanks, thats has worked, really appreciate your help