Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
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. 

 

Can somebody please help?

 

Thanks,

Indhu.1.PNG2.PNG3.PNG

 

1 ACCEPTED SOLUTION
v-yingjl
Community Support
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.data type.png
  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.

View solution in original post

3 REPLIES 3
v-yingjl
Community Support
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.data type.png
  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.

amitchandak
Super User
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 follows1.PNG

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.