Filtering across Data sources with parameters

Although the Quick Filter can be applied to the worksheets using its data source, it can't be applied to worksheets using other data sources. In order to filter multiple data sources with one list, we need either a reference table or a parameter.

While you can use parameters for many important functions, such as determining which worksheets appear on a dashboard, there are some disadvantages:

  • Only one value can be selected at a time
  • The list of values for static parameters, and they need to be maintained manually
  • Parameters are related to the Data sources through the use of calculated fields, which can be complicated to maintain

In the next few exercises, we will accomplish several tasks via the creation ...

Get Tableau: Creating Interactive Data Visualizations now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.