Forum Discussion
Report Matrix - Tooltip for each value
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!
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
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!