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.

     

antfr99's avatar
antfr99
Resolver II
1 year ago

Hi Dilbertfan 

I suggest this measure :

IsSelectedEmployeeTopic =
VAR SelectedEmp = SELECTEDVALUE(Employee[Emp ID])
RETURN
IF (
    MAX(Topic[Emp ID]) = SelectedEmp,
    1,
    0
)

with this formatting in Cell Elements :



 

which should give you this result :

 

 

Regards

Antonio

Dilbertfan's avatar
Dilbertfan
Frequent Visitor
1 year ago

Hi antfr99 

 

Thanks very much indeed for taking the time to respond.

 

This is a great solution, but not quite right for what I need.  This shows all the topics regardless of what organisation you select, but I want the topics to be filtered by the organisation., but then highlighted by the employee.

 

However, I am definitely keeping this one in my back pocket for other use cases.  Love the simplicity of it.

 

Rich