Display original values without any rounding

[Anonymous]

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?

[parry2k · Accepted solution]

@Anonymous so you want to display the number as listed in the "display" in your reply? If yes, then it is not possible.

[v-lionel-msft]

Hi @Anonymous ,

Has your problem been solved?

Best regards,
Lionel Chen

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

[parry2k]

@Anonymous until you change the data type to text in PQ, but then you will not be able to use it in any aggregation.

[parry2k · Accepted solution]

@Anonymous so you want to display the number as listed in the "display" in your reply? If yes, then it is not possible.

[parry2k]

@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]

Those were random numbers from my dataset can be also

Original:

1. 12

2. 1,05

3. 7,3456

4. 1

5. 12,88989898

Display:

1. 12

2. 1,05

3. 7,3456

4. 1

5. 12,88989898

What I have now:

1. 12,00000000

2. 1,05000000

3. 7,34560000

4. 1,00000000

5. 12,88989898

[Anonymous]

Thanks, I know I can do that but I do not want to have 12,00000000 I like to see original 12 (thats in the query).

Is it even possible?

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

Is it like this?

Best regards,
Lionel Chen

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

[parry2k]

@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.⚡