Forum Discussion

M0n5ta09's avatar
M0n5ta09
Helper I
4 years ago
Solved

Report Matrix - Tooltip for each value

Hi All,

 

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

 Person01Person02Person03
01/01/2022DayOffNight
02/01/2022DayOffNight
03/01/2022NightDayOff
04/01/2022NightDayOff
05/01/2022OffNightOff
06/01/2022OffNightOff
07/01/2022OffOffDay
08/01/2022OffOffDay
09/01/2022DayOffNight
10/01/2022DayOffNight

 

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

DateNameComment
01/01/2022Person01Do Something
01/01/2022Person02Do Another Thing
01/01/2022Person03Do Something Else
02/01/2022Person01Do Something
02/01/2022Person02Do Something Else
02/01/2022Person03Do Something
03/01/2022Person01Do Something
03/01/2022Person02Do Another Thing
03/01/2022Person03Do 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/2022Person01Do Something
02/01/2022Person02Do Something Else
02/01/2022Person03Do Something

 

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

 

Thank you in advance.

Need Help
  • M0n5ta09's avatar
    M0n5ta09
    4 years ago

    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!

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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's avatar
      M0n5ta09
      Helper I
      4 years ago

      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!