topic Re: How to stop numbers from rounding in visual in DAX Commands and Tips

How to stop numbers from rounding in visual

Anonymous — Tue, 01 Jun 2021 16:15:20 GMT

PBI Community Good Day

Looking for a solution to prevent the numbers in the visual from rounding up. I would like the change to affect this visual only if possible. I have tried to change the formatting to decimal, but it doesn't prevent the rounding.

Much appreciate your help!

Thank you

Re: How to stop numbers from rounding in visual

Jihwan_Kim — Tue, 01 Jun 2021 16:36:07 GMT

Hi, Anonymous

Please try the below.

Change the display units to None.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

Re: How to stop numbers from rounding in visual

Anonymous — Tue, 01 Jun 2021 16:50:05 GMT

Jihwan Kim

Much appreciate your help.

Thank you!

Re: How to stop numbers from rounding in visual

Anonymous — Tue, 12 Jul 2022 10:58:48 GMT

Hi, am I doing something wrong? My visualisations looks like this and I cannot find a Data Tab option.

My version - 2.106.883.0 64-bit (June 2022)

Not under General either:

Re: How to stop numbers from rounding in visual

Anonymous — Thu, 25 Aug 2022 18:11:46 GMT

So does mine and I can't find it either.

Re: How to stop numbers from rounding in visual

Anonymous — Thu, 25 Aug 2022 18:14:54 GMT

This does not help. My visualization does not look like yours. I do not see the Data Lab or the Display Units under Visual or General.

Re: How to stop numbers from rounding in visual

Anonymous — Thu, 25 Aug 2022 19:52:59 GMT

This visual panel must be from an older version of BI because mine doesn't look like that. This is what mine looks like.

Re: How to stop numbers from rounding in visual

Anonymous — Thu, 25 Aug 2022 19:56:47 GMT

Here is what I found.

How do you stop Power BI from rounding?

Instead of changing decimal places in visuals, you can directly click the column in FIELDS pane and then change decimal places to 9 under Modeling option.

This worked for me very well.

Re: How to stop numbers from rounding in visual

Cel87 — Fri, 15 Mar 2024 03:35:25 GMT

If you are doing this as a card, change the Callout value > Display Units to 'None' to give you the exact amount

Re: How to stop numbers from rounding in visual

CUdatanerd — Wed, 01 May 2024 15:10:47 GMT

This does not prevent rounding.

Anyone else have any luck?

Re: How to stop numbers from rounding in visual

4funksake — Wed, 16 Oct 2024 15:07:30 GMT

Did you manage to find a solution please? I am still stuck. Thanks.

Re: How to stop numbers from rounding in visual

Cel87 — Wed, 16 Oct 2024 21:37:33 GMT

4funksake see the visuals above

Re: How to stop numbers from rounding in visual

4funksake — Thu, 17 Oct 2024 15:53:16 GMT

Rude!