cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

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

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors