Forum Discussion

4J's avatar
4J
New Member
2 years ago
Solved

Issue with tooltip data updating when filtering another visual

Hello, I'm struggling to find a way to get the right output from a tooltip linked to a matrix table when filtering other visuals. Here is the link (https://we.tl/t-8VQXObgaU5) to the PBIX f...
Need Help
  • NaveenGandhi's avatar
    NaveenGandhi
    2 years ago

    Hi 4J 

    When you turn on keep filters in the tooltip page, The year slicer will impact the tooltip, to mitigate this you can create a dummy year table to use in the slicer. Then create below measure to use in page 1 visuals.

    Value page 1 = CALCULATE(TOTALYTD(
                SUM(Data[Value]), 'Calendar'[Date]),'Calendar'[Year]=SELECTEDVALUE('Year'[Year]))

     

    This should resolve the issue. I have attached the updated PBIX, feel free to check it.

    Let me know if this helps.
    If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

    Follow me on LinkedIn!!!

rubayatyasmin's avatar
rubayatyasmin
Community Champion
2 years ago

Hi, 4J 

 

Do you mean like this?

 

4J's avatar
4J
New Member
2 years ago

Hi rubayatyasmin,

Thank you for your reply.

 

I would like to filter the 'Value by category' visual and have the tooltip data in the matrix table updated accordingly. Currently, the tooltip works fine for the matrix table alone, but when I apply a filter to the other visual, the tooltip data does not update as expected.

 

  • NaveenGandhi's avatar
    NaveenGandhi
    Memorable Member
    2 years ago

    Hi 4J 

    When you turn on keep filters in the tooltip page, The year slicer will impact the tooltip, to mitigate this you can create a dummy year table to use in the slicer. Then create below measure to use in page 1 visuals.

    Value page 1 = CALCULATE(TOTALYTD(
                SUM(Data[Value]), 'Calendar'[Date]),'Calendar'[Year]=SELECTEDVALUE('Year'[Year]))

     

    This should resolve the issue. I have attached the updated PBIX, feel free to check it.

    Let me know if this helps.
    If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

    Follow me on LinkedIn!!!