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 ...