This should happen automatially with your dataset when you use actions. The link between the fields here is the fact that related fields are on the same row, i.e. all fields on 'olympic' row are related or 'linked' to each other for Tableau actions.
Thanks for your reply. I am able to what you said in the same Worksheet, but I am having problems in doing that on the dashboard with 2 separate worksheets.
I've attached a sample version of the tableau to reflect what I cannot do at the moment.
Currently, I set up a "use as filter" on Sheet 1 so that once u click a value in Sheet 1, then it will filter it on Sheet 2.
But what I want is not to filter but to highlight (so all the other values can be seen).
Also, I'd like this to work the other way around that if I click a value in Sheet 2 then Sheet 1 will also highlight the correct value accordingly.
Tableau_test.twbx.zip 23.3 KB
When you picked a worksheet to act as a filter, Tableau automatically generated a dashboard action that does just that - filters.
You need to manually create a pair of highlight actions for your dashboard (as shown in the illustration below, with important bits highlighted). You'll need one action for Sheet1 to Sheet2, and another one for Sheet2 to Sheet1.
Also see attached workbook and if you need more info on actions - look up dashboard actions in Tableau help.
Woo thanks! Exactly what I was looking for!