Matrix Visualization tooltip

[GrayGunn5]

I have managed to create a matrix visualization where each cell counts the number of students who study 2 particular subjects in school, i.e. the row and columns are both school subjects and a value of 2 in a cell means that 2 students study those 2 subjects like Art and Business Studies. See below:

Now I would like the tooltip to show the names of the two students who study both Art and Business Studies. 

Any help would be most gratefully recieved as I am new to all this and not a programmer but a teacher.

[v-xiaotang · Accepted solution]

Hi @GrayGunn5 

Thanks for reaching out to us.

you can try this measure, and put it into tooltip page, for more please see the sample file attached below

names = CONCATENATEX(VALUES('Table'[Name]),[Name],",")

result

Best Regards,

Community Support Team _Tang

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

[AbbasG]

@GrayGunn5 yes if you can share the file, I can look and try to help.

[GrayGunn5]

I have put a simpolified mock up of the source file here:

[AbbasG]

@GrayGunn5 the link does not open.

[AbbasG]

@GrayGunn5 

Hi, this is my sample solution, hope it helps to achieve your desired output.

To show the tooltip in the matrix, you have to first create a tooltip page that you want to show, in this case, the name of the students as below.

After that turn on the tooltip option for matrix and select the page that you created earlier.

[GrayGunn5]

Unfortunately that is what I tried but because the values in the matrix are derived from a measure, (calculated on the fly) I can't seem to get it to work. Would it help if I sent you the file?