How to: Create a Cascading Lookup Filter and Apply it Across Tab Pages and Data Sources
- 2 minutes to read
This example illustrates the following techniques:
- master filter settings used to create a cascading lookup filter;
- tab page interactivity settings to isolate master filter items;
- master filter settings applied to different data sources.
The Cascading Lookup With Master Filters document describes how to create a five-level cascading filter.
The filter and the chart item that display filtered data are on a page in a tab page container. The tab page's Master Filter and Ignore Master Filters options are enabled to isolate tab page's items from external filters.
Another tab page in a tab container has the Master Filter and Ignore Master Filters options disabled. The first page's items affect this page's items, and establishes a one-way filter relationship because items on this page cannot filter items on the first page.
The chart on the second page displays data from another data source. That data source's ProductName field matches the name of the field in the first data source, and cascade filtering on the first page can extend to the second page if you enable the Cross-Data-Source Filtering option for the ProductName filter element and all filter elements at the lower levels.
The sample dashboard is shown below.