Forum Discussion
Advocate IChange number format (decimals) for each visual
I made an animated gif.
Community Champion
Hi, if you mantain the Decimals in AUTO in the measure, you can change in every visual that you use it. (Format General)
Regards
Victor
Advocate I
Vvelarde I can't get the measure to stay "Auto" for the decimals if the Data Type is set to Decimals. It defaults to 2. The only way to keep the decimals set to Auto seemed to be to leave it as General Data Format - which means I lose my commas. Also, when I did that, I couldn't figure out where I would change the decimals (and add commas, preferably) in the different visuals. The card visual allows you to change number formats, but the tables don't have a setting for the value decimal places. I found it on a matrix under field formatting, but it was set to "Auto" and grayed out so I couldn't change it. And the tooltips definitely don't give you an option for how to format the numbers that it presents.
This is such a basic kind of formatting function, it is hard to understand why it's so difficult to find or change it or why it's so restricted. I figured I wouldn't be the only one who had trouble with this, so surely there was already a solution, and I just hadn't found it yet....
- Vvelarde
The table visual had a Field Formatting. Look a put the decimals, and could change in the visual.
- twintrbl
Vvelarde 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?