Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Does anybody know what causes Value Decimal Places to be greyed out in the formatting options? This is happening to me regardless of the visual type. It's happening both for measures and aggregated fields. It's happening regardless of the field modeling. I simply do not have the option to change the decimal places.
Solved! Go to Solution.
Click on Auto to get the blinking cursor and scroll your mouse wheel. Revert to default if you want auto again.
MS designs some of the worst user interfaces. So much time wasted on dealing with stuff like this - hope I can save others' time.
thanks a lot for great help. i almost broke my head for 2 days !!!. thanks again.
It's really sad that Microsoft hasn't fixed this yet (enable the up and down buttons to increment the decimal places). Is anybody at MS aware of this? I have to imagine it's only like 1 or 2 lines of code to fix.
I wonder, is that supported for microsoft?
I found that formatting is avaible since december 2017, but somehow it seems to be a trouble for many people.
I am able to edit that even when connecting live to SSAS, from my concern this alright cuz its only way to format number in DATAVIZ, would not change perfommance at all.
But I did not found any microsoft documentation to guarante i will not have to rework, if some new changes with new updates.
What you guys think, is that worth to set it by hand?
I did not understand why it always "Grayed out" and does not work with click or its just concept auto is not 0 or any number then it can go up/down from any conclusion.
Or click over "Auto" and submit your value and enter.
Click on Auto to get the blinking cursor and scroll your mouse wheel. Revert to default if you want auto again.
MS designs some of the worst user interfaces. So much time wasted on dealing with stuff like this - hope I can save others' time.
thanks so much! what an insane solution!
Wonderful. Thanks for the answer. I've spent hours on it already.
@Anonymous I can't see the defalut option. Please see below..... am i missing anything????
It's seem as disable but if you type a number will be enable.
@Anonymous There is definetly something wiered with new release of PBI. I used to have this option in earlier version. My issue occour when i am using any sort of % chart like 100% stack or Pie chart.....My dimension is of whole number......
OMG. That is so dumb (the problem, not the solution). Thank you for sharing, this would have taken me forever to figure out otherwise. Yeesh.
What's the answer?
Wonderful to find a post that is solved. Thank you so much @Anonymous for the help.
This is the solution!
You saved my time indeed.
@Anonymous Thank you so much!
Hi Trudgeon,
Have you solved your issue by now? If you have, could you please mark my answer to finish this thread?
Regards,
Jimmy Tao
This item is not resolved. I don't see how it can be a data formatting issue. I very recently added a new card (YTD BUDGET VM) to a report and the ability to change decimal places is uneditable. This card is from on the same exact measure as an older card (YTD VARIABLE MARGIN) which does allow me to edit the decimal places. It is the same measure.
The only reason I think of is perhaps a recent update from Microsoft removed this functionality. I don't know. I'm at a loss
New Card does not allow decimal editing
Old Card does allow decimal editing
Hi Trudgeon,
This is related with your data field, could you please share some sample data? Value decimal place in data label can be selected on my side.
Regards,
Jimmy Tao
This helped me immensley! Thanks
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
144 | |
73 | |
64 | |
52 | |
51 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |