Forum Discussion
twintrbl
Advocate I
Advocate IChange number format (decimals) for each visual
I know we can change number formats to control how many decimals show for any given measure, but it doesn't look like we can change that format on different visuals. For example - in one visual I mig...
I made an animated gif.
twintrblAdvocate I
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....
