Forum Discussion
Highlight Table Rows from Selection in Another Table
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 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.
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