The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
Solved! Go to Solution.
Hi @Anonymous ,
Issue 1:
You can try these ways if you just want to show whole number in the table:
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.
Hi @Anonymous ,
Issue 1:
You can try these ways if you just want to show whole number in the table:
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.
If I increase the value it appears as follows
User | Count |
---|---|
87 | |
84 | |
36 | |
35 | |
32 |
User | Count |
---|---|
96 | |
75 | |
67 | |
52 | |
52 |