Forum Discussion

jyaul786's avatar
jyaul786
Helper II
3 years ago
Solved

Tooltips single page

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

 

Need Help
  • Prateek97's avatar
    Prateek97
    3 years ago

    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.

1 Reply

  • Prateek97's avatar
    Prateek97
    Resolver III
    3 years ago

    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.