Change number format (decimals) for each visual

[twintrbl]

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!

[Nathaniel_C]

That looks like a good suggestion for the Power BI Team! Is there a place to suggest that?

[Vvelarde]

@twintrbl 

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

[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.... 

[Vvelarde]

@twintrbl 

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?

[Vvelarde]

@twintrbl 

Hi, just enter the number of decimals of you desire. Don't work using the up and down arrows.

[Vvelarde · Accepted solution]

I made an animated gif.

[h4tt3n]

Thanks, spent some time looking for this in the formatting menu - it is well hidden 🙂

[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!!