Forum Discussion
Advocate IChange number format (decimals) for each visual
I made an animated gif.
Community Champion
The table visual had a Field Formatting. Look a put the decimals, and could change in the visual.
Advocate IVvelarde The option for changing the Value decimal places in the Field formatting section is grayed out. Eveni f I change the display units to Thousands, the Value decimal places is still grayed out. Nor do I see any options in the toolbars... You can see in the screenshot below that when I formatted the measure to General, it looks horrible now - it has a mixed number of decimals and there is no thousands separator. I've been hunting, but I can't find anywhere that I could change the number format to add the comma and change it to force two decimals for this one table. What am I missing? Is there a setting somewhere else that I'm overlooking?
- Vvelarde
Hi, just enter the number of decimals of you desire. Don't work using the up and down arrows.
- Vvelarde
I made an animated gif.
- twintrbl
Vvelarde WOW! I'm floored! When that box was grayed out, I assumed it meant it wasn't editable. That's pretty standard functionality over the last... what, 15 years? But you were totally right - I just tried it, and it works perfectly to just type a number in there.
Now I'm going to start trying to override all kinds of things that are grayed out, just to see what Microsoft might be hiding!
Thank you so much!!