Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Wrong Information

I need help with some data
I have a table at Excel where I have some numbers (all are decimals) but at the moment that I export the data to Power BI the information changes, and Power Bi round the data to 1 instead of keeping the same numbers that I have

Need Help

5 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous seem like data type is change to %, change it to Number and see if that fixes the issue.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Dind't work

      • parry2k's avatar
        parry2k
        Super User
        6 years ago

        Anonymous if it is not too much to ask, please put a sample excel sheet and pbix file and share with amazing team here. Remove any sensitive information before sharing. There could be many reasons for the issue as you can see multiple people replied multiple options. 

         

         

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion
    6 years ago

    Hi Anonymous ,

     

    Go to modeling and change the format.

     

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel

     

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Under the modeling tab, can you change not of decimal place and check