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...
  • 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.