Mouse Over tooltip - Number Format

[Anonymous]

Hello all

I am puzzled with formatting the information that shows when I mouse over a clustered bar chart. 

My visual has 2 values ACT YTD and BUD YTD, when I mouse over the ACT YTD the number of the tooltip is a whole number with 3 decimals. When I mouse over the BUD YTD the number is a whole number with no decimals.

Is there a way to: 

First: Both values to have the same format, preferably no decimals.

Second: how to further format the tooltip on mouse over. For example can I show the numbers in thousand, million etc?

Thanks  a lot

fanis

[Biru]

Has this been resolved yet ? Can we supress the original tool tip value to not display when we hover the mouse on the visualizations ?

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

We can create a measure as below and add it to the tooltip to work around.

For more details, please check the pbix as attached.

[mwegener]

Hi @Anonymous ,

use the Modeling tab, select the column which you want to format and choose the format.

Or look at this.

https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings

[dharm_harley]

This is the best solution!!!