Forum Discussion

peoplehelpme's avatar
peoplehelpme
Icon for Helper I rankHelper I
3 years ago

Why data loaded in power bi is zero

From excel i have data like this

but when i loaded to power bi ,i got this

Please help me, I am very thank you

Need Help
Show and Tell

2 Replies

  • JoeBarry's avatar
    JoeBarry
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Hi peoplehelpme 

     

    Try transforming the column to Number in Power Query, this will provide a decimal number

     

    thanks

    Joe

     

    If this post helps, then please Accept it as the solution

  • Nandha_Kumar_SR's avatar
    Nandha_Kumar_SR
    Frequent Visitor
    3 years ago

    Its because power BI removes the zeros which are in the end after the decimal point when the FORMAT is GENERAL and the DATATYPE is DECIMAL NUMBER. You can change the No. of decimal places for all values in column tools.