Forum Discussion

GrayGunn5's avatar
GrayGunn5
Frequent Visitor
3 years ago
Solved

Matrix tooltip

I have a table of elements such as:

 

Each person can have multiple categories. From this table I have managed to create a matrix like this:

 

In order to achieve this (with help from this forum) I used the following Measure to aggregate the numbers:

 

Measure = if(VALUES(Classification[Classification])=VALUES(Classification_dup[Classification]),0,CALCULATE([People],CALCULATETABLE(SUMMARIZE(VALUES(Data[IdPerson]),Data[IdPerson]),ALL(Classification),USERELATIONSHIP(Data[Classification],Classification_dup[Classification]))))
 

I am now struggling with trying to create a tooltip that shows the Name (or ID) of the people in each cell, i.e. I want to create something that liiks like this:

 

 

 

The mock up file is attached below:

 

https://www.dropbox.com/s/i2wrw6zowwjzxs0/Cross%20matrix%20example%20post.pbix?dl=0 

 

I would be very grateful for any help.

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi GrayGunn5 ,

     

    I think you can try to create this measure to filter your visual in your tooltip page.

    Filter = 
VAR _C1 =
    SELECTEDVALUE ( Classification[Classification] )
VAR _C2 =
    SELECTEDVALUE ( Classification_dup[Classification] )
VAR _VALUES =
    CALCULATETABLE (
        VALUES ( Data[IdPerson] ),
        FILTER ( ALL ( Data ), Data[Classification] = _C2 )
    )
RETURN
    IF ( _C1 = _C2, 0, IF ( MAX ( Data[IdPerson] ) IN _VALUES, 1, 0 ) )

    Here I create a table visual by 'Data'[IdPerson] and keep all filters from 'Classification'[Classification].

    Add this measure into visual level filter and set it to show items when value = 1.

     

    Result is as below.

    For more details: Create tooltips based on report pages

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi GrayGunn5 ,

     

    I think you can try to create this measure to filter your visual in your tooltip page.

    Filter = 
VAR _C1 =
    SELECTEDVALUE ( Classification[Classification] )
VAR _C2 =
    SELECTEDVALUE ( Classification_dup[Classification] )
VAR _VALUES =
    CALCULATETABLE (
        VALUES ( Data[IdPerson] ),
        FILTER ( ALL ( Data ), Data[Classification] = _C2 )
    )
RETURN
    IF ( _C1 = _C2, 0, IF ( MAX ( Data[IdPerson] ) IN _VALUES, 1, 0 ) )

    Here I create a table visual by 'Data'[IdPerson] and keep all filters from 'Classification'[Classification].

    Add this measure into visual level filter and set it to show items when value = 1.

     

    Result is as below.

    For more details: Create tooltips based on report pages

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.