Forum Discussion

YunJ's avatar
YunJ
Post Prodigy
6 years ago
Solved

Number format different from original excel

Hi,

 

In my excel data, Sales are Decimal numbers with 2 digits after the point. But in pbi it always show .00 although I have already set as Decimal number...

Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago

    Hi YunJ ,

     

    According to my test, when I import data of decimal number and change the data type to whole number, the data will be overwritten. Clicking refresh  button can solve this problem.

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi,

     

    If you convert to number in excel your figures, in Power BI you will have them with the same format and Power BI won't round it. 

     

    See below. If this helped you please mark this as solution.

     

     

     

    Best regards,

    Alin Oprita

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    6 years ago

    Hi YunJ ,

     

    According to my test, when I import data of decimal number and change the data type to whole number, the data will be overwritten. Clicking refresh  button can solve this problem.

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.