Forum Discussion

rakhipatil88's avatar
rakhipatil88
Frequent Visitor
4 years ago

undefined

In powerbi Dashboard I am not able show values like 0.01,0.02,0.03......like wise..
These above values that I am taken from excel sheet.How to solve this problem?

9 Replies

  • rakhipatil88 , set the format 0.00

     

     

    If this does not help
    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

  • rakhipatil88's avatar
    rakhipatil88
    Frequent Visitor

    I tried this but values are not come as mentioned above.

     

    I have merged this excel sheet to other powerbi table in this not showing the values.

    otherwise single excel sheet it shows that value. dont know where m getting wrong.

  • rakhipatil88's avatar
    rakhipatil88
    Frequent Visitor

    I tried above given solution but not getting output in my scenario.

    Plz help

  • rakhipatil88 what is the data type for this column in power query, is it a whole number or decimal number?

     

    Follow us on LinkedIn and  to our YouTube channel

    I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    • rakhipatil88's avatar
      rakhipatil88
      Frequent Visitor

      Decimal Number...And I tried and tested with all the data type but not getting the output.

  • rakhipatil88 share the pbix file, remove sensitive information before sharing, share using one drive/google drive.

    • rakhipatil88's avatar
      rakhipatil88
      Frequent Visitor

      Thank You all of you..

      I got the solution for my above problem...Its working now..

  • rakhipatil88 you should post the solution so that others can take help from it.

     

    Follow us on LinkedIn and  to our YouTube channel

    I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    • rakhipatil88's avatar
      rakhipatil88
      Frequent Visitor

      In that particular merged table I had taken wrong applied steps so thats why I am not able to see those values. Path is Home-->Transform data-->Select particulat table-->Applied steps

      See below image.