cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## Get values in decimal format

Hi all,

I was playing around modeling, the actual data is in decimal format. I wanted that to round off to the nearest integer. I accidentally used modeling to use that now I am having trouble formatting the value again.

The actual value is 1748210. However, in modeling, I changed the decimal value to 0 now I am getting the value to be 1,705,000.

Issue 1:

What I actually wanted to do is if the value is 1748210.12 that to be 1748210 or 1748210.9 to be 1748211. Since I am putting that in the table.

Issue 2:

Since I change that in the modeling view, now I cannot change that to auto.

Thanks,

Indhu.

1 ACCEPTED SOLUTION
Community Support

Hi @Anonymous ,

Issue 1:

You can try these ways if you just want to show whole number in the table:

1. Change the data type from Decimal number into Whole number directly.
2. Change the number of decimal places into 0 as you previously posted

Issue 2:

Im not certain what did However, in modeling, I changed the decimal value to 0 now I am getting the value to be 1,705,000 mean?  How did you do that to show the value as 1705000? Did you mean change the number of decimal places into 0 then the value has changed into 1705000 like your previously posted pictures? If the scenario is like your previously posted pictures, maybe you can submit this issue to https://community.powerbi.com/t5/Issues/idb-p/Issues  for further support. If not, could please share more details or post other pictures for further discussion because after I changed the number of decimal places into 0 it shown as 1748210 normally.

Best Regards,

Yingjie Li

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

3 REPLIES 3
Community Support

Hi @Anonymous ,

Issue 1:

You can try these ways if you just want to show whole number in the table:

1. Change the data type from Decimal number into Whole number directly.
2. Change the number of decimal places into 0 as you previously posted

Issue 2:

Im not certain what did However, in modeling, I changed the decimal value to 0 now I am getting the value to be 1,705,000 mean?  How did you do that to show the value as 1705000? Did you mean change the number of decimal places into 0 then the value has changed into 1705000 like your previously posted pictures? If the scenario is like your previously posted pictures, maybe you can submit this issue to https://community.powerbi.com/t5/Issues/idb-p/Issues  for further support. If not, could please share more details or post other pictures for further discussion because after I changed the number of decimal places into 0 it shown as 1748210 normally.

Best Regards,

Yingjie Li

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

Super User

Increase the decimal place and check. Sometimes it does not reflect immediately

Anonymous
Not applicable

If I increase the value it appears as follows

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors