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 of three parameters. We will create parameters that integrate with calculated fields to:
Show a single year in one graph and a range of years in another graph
Filter across multiple Data sources
Allow users to select the detail that needs to be explored...