How to create a Tooltip text, that can be altered by filters?

[Anonymous]

Good afternoon to everyone reading this,

It looks like a simple problem, but I haven't figured this out.

In my report, I have a dashboard which can be filtered by year, month and subcompany. Then I have some graphs, which I created a specfic custom tooltip for each. In my custom tooltip, I have another graph and a text under it, explaining it. However, if I change the subcompany, the values are different, and I need a different text to explain and interpret the graphic, the tooltip graphic is working fine, but the text won't change. I will probably have to create multiple tooltips for each graph, with different texts in each one of them, but I'm not sure if its the best way, nor how to make it, because a graph can only have 1 tooltip.

Anyone has ideas on how to make this work?

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

I created a simple sample. You could have a try and check if it is what you want.

Measure =
VAR vSelectedValue =
    HASONEFILTER ( 'Table'[Country] )
RETURN
    SWITCH (
        vSelectedValue,
        MAX ( 'Table'[Country] ) = "Canada", "A",
        MAX ( 'Table'[Country] ) = "Germany", "B",
        MAX ( 'Table'[Country] ) = "France", "C",
        MAX ( 'Table'[Country] ) = "Mexico", "D"
    )

For more details, please see the attachment. If it is not what you want, please share a few screenshots or more details about it. We will understand clearly.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

Seems like you want to use ISINSCOPE

[Anonymous]

@Greg_Deckler I'm not familiar with that funcion, how would it look like?

Anyway, thanks @v-xuding-msft for the solution! Works just fine 😃

[v-xuding-msft]

Hi @Anonymous ,

Glad it works for you. 😊

For the function of ISINSCOPE that Greg suggests, I add some blogs that you could reference.

ISINSCOPE

New DAX function: ISINSCOPE 

https://info.enterprisedna.co/dax-function-guide/isinscope/ 

Use IsInScope to get the right hierarchy level in DAX 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

ISINSCOPE is kind of the more modern version of HASONEVALUE.