Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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. 

 

Can somebody please help?

 

Thanks,

Indhu.

 

Need Help
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    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.

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      If I increase the value it appears as follows

       
  • v-yingjl's avatar
    v-yingjl
    Community Support
    6 years ago

    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.