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(to...
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.
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.