Tooltips single page

[jyaul786]

Dear Friends,

i have table with Product,Product value and Group ID, Group value.

and separte column chart for both Product and Group ID and one tooltip page.

and i want to get value(tooltip) through single custom tooltip page. means whenever i hover to Product column chart, it will pop up with 'Product Value' and whenever i hover to Group column chart, it will pop up with 'Group Value'. how can i achieve this from single custom tooltip page. with help of DAX.

-without unpivot column at power query side

[Prateek97 · Accepted solution]

Hi @jyaul786 ,

You can create a dynamic measure which will change values based on the filtered dimension. Something like this:

Tooltip Test =

IF(ISFILTERED('Table'[Product]),

    SUM('Table'[Product Value]),

SUM('Table'[Group Value])).

Then on the tooltip page, put this measure in a card. This should work. Let me know if it is still stuck.

Please mark as answer if your issue is solved.