Card displays in millions; can a hover-over be in thousands?

[AliceW]

Hi everyone,

I have this issue with the otherwise awesome Card visual.

I need to format it in millions with one decimal (0.0M).

However, some cards have small enough amounts that they show 0.0.

On tooltip, unfortunately, the same format is kept.

Would anyone have a trick up their sleeve for me to display the amount in thousands on hover-over?

[Greg_Deckler · Accepted solution]

@AliceW What about something like:

Measure = 
    VAR __Value = [Original Measure]
    VAR __Millions = __Value / 1000000
RETURN
    IF(__Value < 100000, FORMAT(__Value,"#.0"),FORMAT(__Millions,"#.0M"))

[mwegener · Accepted solution]

Hi @AliceW ,

you can create your own tooltip

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips?WT.mc_id=DP-MVP-5004288

[AliceW]

These are some awesome solutions, guys! Thank you SO MUCH!!!

[jdbuchanan71]

@AliceW 

What happens if you set the Display units to Auto instead of Millions?  In my test:

[AliceW]

Hi JD, I actually need them to be in 0.0M for everything to keep the users' expectations in place. I do have that in other reports though!

[mwegener · Accepted solution]

Hi @AliceW ,

another possibility would be to use the hover effect of a button.

Embedding Hover Effect Tooltips to a "Card" Visual in Power BI

https://youtu.be/49XjvqjAo58

[mwegener · Accepted solution]

Hi @AliceW ,

you can create your own tooltip

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips?WT.mc_id=DP-MVP-5004288

[Greg_Deckler · Accepted solution]

@AliceW What about something like:

Measure = 
    VAR __Value = [Original Measure]
    VAR __Millions = __Value / 1000000
RETURN
    IF(__Value < 100000, FORMAT(__Value,"#.0"),FORMAT(__Millions,"#.0M"))