Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to use measure to display dynamic tooltip by Row Input on Matrix?

Hi there,   I've reviewed many related posts in the community, but haven't found the solutions yet...so ask here I have below Matrix with hierarchy: Group-ID-Location-Vendor, each of the tier has ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Thanks for all the replies! I've solved this issue using ISFILTERED as below

    So when I'm at Vendor level on the Matrix, it pops up tooltip for Vendor-level indicator when hover over; when at Location level, it pops up for Location-level indicator....etc.  The tooltip dynamically changes based on the hierarchy on the Matrix.

     

    Tooltip =
SWITCH(TRUE(),
    ISFILTERED(Table4[Vendor]),
        SUM(Table4[Indicator1]),
    ISFILTERED(Table3[Location]),
        SUM(Table3[Indicator1]),
    ISFILTERED(Table2[ID]),
        SUM(Table2[Indicator1]),
    ISFILTERED(Table1[Group]),
        SUM(Table1[Indicator1])
)

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous,

ISINSCOPE function is checked based on current row contents. When you use that formula on the card, It's row content is the whole table and corresponds filter effect which you applied on that table. So ISINSCOPE function not able to check on the different hierarchy levels.
For your scenario, you can add some visual level filters to a specific particular row content level.
Regards,

Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for all the replies! I've solved this issue using ISFILTERED as below

So when I'm at Vendor level on the Matrix, it pops up tooltip for Vendor-level indicator when hover over; when at Location level, it pops up for Location-level indicator....etc.  The tooltip dynamically changes based on the hierarchy on the Matrix.

 

Tooltip =
SWITCH(TRUE(),
    ISFILTERED(Table4[Vendor]),
        SUM(Table4[Indicator1]),
    ISFILTERED(Table3[Location]),
        SUM(Table3[Indicator1]),
    ISFILTERED(Table2[ID]),
        SUM(Table2[Indicator1]),
    ISFILTERED(Table1[Group]),
        SUM(Table1[Indicator1])
)