Forum Discussion

hariaw's avatar
hariaw
Frequent Visitor
2 years ago

Tooltip show different visuals based on the matrix mouseover selection

Hallo all,

 

I would like to create a tooltip, where it shows different visual depending on where the mouse is hovering on a matrix. For example, if I have a matrix containing 3 row-fields (3 hierarchy levels):

- branch

- supervisor

- employee

 

and 1 value-field:

- working hours

 

I want to create a tooltip that shows the supervisors detail when I hover on the branch cell, and shows employees details when hovering the supervisor cell. Is it possible to do that? Or perhaps do you know a way around?

 

Thank you

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    2 years ago

    hariaw , Create a measure like, assuming working hours is a measure

     

    M1=  calculate([working hours], removefilters(Table[employee] ) )

     

     

    M1=  calculate([working hours], filter(allselected(Table), Table[supervisor] = max(Table[supervisor] )  ) )