Forum Discussion

Dilbertfan's avatar
Dilbertfan
Frequent Visitor
1 year ago
Solved

Highlight Table Rows from Selection in Another Table

Hi All   I have an issue with highlight rows in a table which I havent been able to find a suitable answer to from the various posts on highlighting rows using disconnected tables.   The Data I ...
Need Help
  • SamWiseOwl's avatar
    SamWiseOwl
    1 year ago

    Dilbertfan  I had another think about this and tried to solve the exact thing you wanted.
    Now I don't know how scaleable this will be but I did get it working.

    First I created a measure that would read who the orginisation was and force every possible Topic they might have to show. To make this neat I deleted the column header and set the measure to return an empty string "".

    Then I read the row and checked which person had been clicked in the table and if their topic matched the row set it to yellow.

     

SamWiseOwl's avatar
SamWiseOwl
Super User
1 year ago

 

Hi Dilbertfan 

 

You need a second copy of the employee list and use this to read which Name the report user has clicked.

Then change the colour based on a measure:

Highlight row measure =
 VAR CurrSlicer = SELECTEDVALUE('Employee Table'[Selected Name]) --chosen person in slicer
 var filtTopics =
 CALCULATETABLE(VALUES(Topics[Topic]), Employee[Name] = CurrSlicer) --what hobbies does that person like

 RETURN
 IF(
    SELECTEDVALUE(Topics[Topic]) IN filtTopics --if current row in list then change colour
    ,"Yellow" --apply yellow or use hex codes to get specific colours #00FF00 would be green
 )
  • SamWiseOwl's avatar
    SamWiseOwl
    Super User
    1 year ago

    Dilbertfan  I had another think about this and tried to solve the exact thing you wanted.
    Now I don't know how scaleable this will be but I did get it working.

    First I created a measure that would read who the orginisation was and force every possible Topic they might have to show. To make this neat I deleted the column header and set the measure to return an empty string "".

    Then I read the row and checked which person had been clicked in the table and if their topic matched the row set it to yellow.

     

    • Dilbertfan's avatar
      Dilbertfan
      Frequent Visitor
      1 year ago

      Hi SamWiseOwl 

       

      Thanks very much for taking the time to respond - really appreciate it.

       

      Yes this works great and I understand the rationale behind the Force Measure.

       

      The only minor hiccup is that when you select a individual, say Sally in Tesco, if you then switch to Waitrose, the topics are blank until you click on Fred because it still thinks it should be based on Sally from Tesco who doesn't exist in Waitrose.  However, this is minor issue and similar to the slicer issue when values remain in another slicer

       

      Could this be used with a Button Slicer to select the employee rather than a table?

       

      Anyway, I can move forward with this now - so fanastic bit of help.  Going to have a lot of fun documenting the 2 measures ğŸ˜€

       

      Rich