How to add same filter to multiple data sources in tableau server?

Question

I have three data sources A, B and C. All three of them have a field called proxyid. I cannot blend them because of usage of complex calculations. I have created three worksheets using these data sources respectively. I am creating a dashboard with these three worksheets. I want to use proxyid as a single filter which can span these three worksheets.

But currently I have three proxyid as filters each for their corresponding worksheet in dashboard. How can I use only one filter which can filter all three of the worksheet?

Answer 1

You want to apply a filter to related data sources - which is an option if multiple data sources have a field with the same name and data type, or if you define explicit relationships between data sources from the Data menu.

Then you can simply show one filter control on your dashboard and set it to apply to all related data sources.

The parameter approach Andy mention works too, and used to be the main alternative before Tableau added this feature, which takes less effort to setup.

Answer 2

If only selecting one proxyid at a time you could flip your filter to be a parameter instead. For single select this works well and could filter all of your data sources in one.