Report Matrix - Tooltip for each value

[M0n5ta09]

Hi All,

I have a matrix visual in a report similar to this...

	Person01	Person02	Person03
01/01/2022	Day	Off	Night
02/01/2022	Day	Off	Night
03/01/2022	Night	Day	Off
04/01/2022	Night	Day	Off
05/01/2022	Off	Night	Off
06/01/2022	Off	Night	Off
07/01/2022	Off	Off	Day
08/01/2022	Off	Off	Day
09/01/2022	Day	Off	Night
10/01/2022	Day	Off	Night

...and data for a comments table like this, with a relationship between dates 

Date	Name	Comment
01/01/2022	Person01	Do Something
01/01/2022	Person02	Do Another Thing
01/01/2022	Person03	Do Something Else
02/01/2022	Person01	Do Something
02/01/2022	Person02	Do Something Else
02/01/2022	Person03	Do Something
03/01/2022	Person01	Do Something
03/01/2022	Person02	Do Another Thing
03/01/2022	Person03	Do Another Thing

I have created a tooltip with a table and when I hover over a value, for example Person03 on 02/01/2022, I get everything for 02/01/2022, like this... 

02/01/2022	Person01	Do Something
02/01/2022	Person02	Do Something Else
02/01/2022	Person03	Do Something

Is it possible, so that it only shows the details for Person03?

Thank you in advance.

[amitchandak]

@M0n5ta09 , I doubt this can done based on column. But using transparent color can be an option like

example

BG color

IF(ISFILTERED(Table[ID]) && hasonevalue(Table[Person]) && max(Table[Person]) ="Person 3","White" ,"#FFFFFF00")

Font color

IF(ISFILTERED(Table[ID]) && hasonevalue(Table[Person]) && max(Table[Person]) ="Person 3","Black" ,"#FFFFFF00")

Use that in Page color, Table color (Background) using fx field value

and font using fx field value option

[M0n5ta09 · Accepted solution]

Thanks @amitchandak,

After numerous trials and errors, I've got it to work. Whether it's the best way, I don't know.

• I added a merged column in both tables, merging the 'Date' and 'Name' columns.
• Then created a relationship between both merged columns.
• For asthetics, I removed the table in the Tooltip and used cards for the 'Date', 'Name' and 'Comment' columns.

Now when I hover over each value, it only shows me the comments for that Person on that Date. Which is what I needed.

Thanks again for your time!