Show value in Millions in the tooltip of bar chart

[simrantuli]

Hi All,

I have a requirement to show values in Millions in the Data labels as well as the tooltip of a bar chart.

Setting it to Millions in the Display units dropdown only works for the Data labels not for the values in the tooltip.

I also tried using FORMAT function in my dax expression to change the value to Millions. However, it doesn't work at all. It makes my chart go blank.

Please help.

Thanks & Regards

Simran Tuli

[Greg_Deckler · Accepted solution]

@simrantuli - OK, I tried a couple different ways but couldn't get it. I'm thinking you do this, if "Measure" is your original measure, maybe:

Tooltip Measure = [Measure]/1000000 & "M"

You could use that in your Tooltip. Downside, original value will still be displayed as well.

[v-eqin-msft · Accepted solution]

Hi @simrantuli ,

You could use Format() to custom tooltip  

tooltip =

FORMAT ( SUM ( 'Table'[Cost] ) / 1000000, "#M" )

My visualization looks like this:

Did I answer your question ? Please mark my reply as solution. Thank you very much.

If not, please upload some insensitive data samples and expected output.

Best Regards,

Eyelyn Qin

[Greg_Deckler]

@simrantuli - Perhaps try custom format strings as in Chelsie Eiden's Duration - https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389

[simrantuli]

Hi @Greg_Deckler ,

Could you please elaborate a bit on how can I use this approach mentioned in the blog that you shared to show values in millions (including the tooltip).

Thanks a lot for your help!

[Greg_Deckler · Accepted solution]

@simrantuli - OK, I tried a couple different ways but couldn't get it. I'm thinking you do this, if "Measure" is your original measure, maybe:

Tooltip Measure = [Measure]/1000000 & "M"

You could use that in your Tooltip. Downside, original value will still be displayed as well.

[simrantuli]

Hi @Greg_Deckler,

Sadly, it doesn't work 😞

[Sumanth_23]

@hi @simrantuli - I was able to implement the solution using the approach mentioned by @Greg_Deckler. 

See screen grab below for the same. 

Please provide a 👍 if my comment helped with solving your issue. Thanks!

[Greg_Deckler]

@simrantuli Did you get an error or can you share a screen shot of the issue?

[simrantuli]

@Greg_Deckler,

Sorry. I was making a mistake while creating the measure. Your solution works. 

However, as you mentioned, the original value still gets displayed.

Best Regards

Simran Tuli

[Greg_Deckler]

@simrantuli Glad you got it. Yeah, I don't know of a way to get rid of that default part of the tooltip. Only thing I can suggest would be to use a Tooltip Page but that might be overkill.