Forum Discussion
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
- amitchandakSuper User
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. - rakhipatil88Frequent 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.
- rakhipatil88Frequent Visitor
I tried above given solution but not getting output in my scenario.
Plz help
- parry2kSuper User
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!
- rakhipatil88Frequent Visitor
Decimal Number...And I tried and tested with all the data type but not getting the output.
- parry2kSuper User
rakhipatil88 share the pbix file, remove sensitive information before sharing, share using one drive/google drive.
- rakhipatil88Frequent Visitor
Thank You all of you..
I got the solution for my above problem...Its working now..
- parry2kSuper User
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!
- rakhipatil88Frequent 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.