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 might want my measure to be Currency with 2 decimal points (in a table, for example). But in another one (such as a card visual or a tooltip for a bar chart), I want it with zero decimal points. I could create a second measure and have one with decimals and one without, but that's a real waste to have to duplicate things that way (and maintain them!).
Any other ideas for how to do this?
Thanks!
I made an animated gif.
9 Replies
twintrbl
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....
- Nathaniel_C
Community Champion
That looks like a good suggestion for the Power BI Team! Is there a place to suggest that?
