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.

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.

Value Decimal Places greyed out. Why? | Microsoft Fabric Community

20 Replies

Anonymous
Not applicable
7 years ago
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.
- mjc543
  Advocate II
  7 years ago
  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.
  - CMillheisler
    Advocate II
    5 years ago
    What's the answer?
- Anonymous
  Not applicable
  6 years ago
  Wonderful. Thanks for the answer. I've spent hours on it already.
- Trudgeon
  Helper III
  7 years ago
  Anonymous Thank you so much!
v-yuta-msft
Community Support
7 years ago
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
- Jenks2019
  New Member
  6 years ago
  This helped me immensley! Thanks
v-yuta-msft
Community Support
7 years ago
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
- Trudgeon
  Helper III
  7 years ago
  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
Anonymous
Not applicable
7 years ago
Or click over "Auto" and submit your value and enter.
Anonymous
Not applicable
7 years ago
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.
Anonymous
Not applicable
6 years ago
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.
wilsjohnc
Regular Visitor
6 years ago
thanks a lot for great help. i almost broke my head for 2 days !!!. thanks again.