Get values in decimal format

[Anonymous]

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. 

Can somebody please help?

Thanks,

Indhu.

[v-yingjl · Accepted solution]

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:

I’m 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.

[amitchandak]

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

[Anonymous]

If I increase the value it appears as follows