Get values in decimal format

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.