Matrix tooltip

[GrayGunn5]

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.

[v-rzhou-msft · Accepted solution]

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.

[lbendlin]

Matrix visuals do not support custom tooltips. If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.powerbi.com