Forum Discussion
Display original values without any rounding
I have those numbers in my report:
12
1,05
7,3456
1
12,88989898
Power BI automatically rounds to 2 decimals, I know that you can put fix decimalas, but I want to avoid 12,00000000
Do you know how to display original values?
Anonymous so you want to display the number as listed in the "display" in your reply? If yes, then it is not possible.
Hi Anonymous ,
Is it like this?
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
8 Replies
Anonymous change the decimal places, instead of keeping decimal places to 2, change it to 8 or 10, depending on you need
Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020
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!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Hi Anonymous ,
Is it like this?
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous sorry I'm confused, your original data has value 12 then what is the number 12,88989898
Sorry, it is not clear, how the raw data looks like, how you want to display it.
Anonymous so you want to display the number as listed in the "display" in your reply? If yes, then it is not possible.
Anonymous until you change the data type to text in PQ, but then you will not be able to use it in any aggregation.
Hi Anonymous ,
Has your problem been solved?
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.