Update: Tableau 10 is here! Download now to try out the feature outlined below.
We’re thrilled to bring you one of our most requested features of all time. In Tableau 10, you can filter across multiple data sources!
Let’s say you’re connected to multiple data sources, each with common dimensions like Date, Product, or Location. And as part of your analysis, you want to have a single filter apply across all the sources.
That’s where this new feature comes in. Any time you have data sets that share a common dimension, you can filter across the data sets.
Let me show you how this works. The following example shows profit and sales. We have two data sources, Coffeechain and Superstore. They both contain the dimension State.
1. From the dashboard, add a State filter to the Coffeechain data set.
2. From the “Apply to worksheets” menu, select “All using related data sources.”
That’s it. We’ve just applied a filter across several data sources!
So how does this work? Applying a filter to “All using related data sources” adds the filter to any worksheet whose primary data source is in a relationship with the filter field. For related sources, the action creates a new filter that populates with the domain from the filter’s data source.