Using a cascading member filter
A cascading member filter displays each level of a hierarchy on separate dropdown lists. Each dropdown is filtered based on what is selected on the parent level dropdown.
Pre-requisites: In order to take advantage of separate dropdowns for each hierarchy level, you need to be using a hierarchy with multiple levels. These can be created from the main menu or in an OLAP cube. Data used in this sample is based on the Data Cube created from the article Using a data cube to join tables.
2. Setting up the cascading filter
Select the multi-level hierarchy along with other data in a metric set on the dashboard.
From the toolbar, add a Cascading Member filter.
Connect the filter to your hierarchy.
Select Bikes on the first level dropdown (Product Category level).
Click on the second level dropdown. The members listed should belong to the parent level (Bikes). Select Mountain Bikes.
Click on the third level dropdown. The members listed should belong to the parent level (Mountain Bikes). Select Mountain-100 Black, 42.
- Hide Token Menu: If this option is selected, the triangular token menu button will not be displayed.
- Manual Items: If enabled, the item(s) are manually controlled instead of auto-populated from your data. This is most useful when using this control with script instead of with a parameter, and does not apply when connected to a view parameter and hierarchy.
- Show Checkboxes: Enable the user to select multiple items. This only applies to the last hierarchy picker.
- Set Value On Any Filter Change: By default, any visualizations affected by this filter will only update when a value is chosen in the last dropdown. Enabling this option will cause the visualizations to update whenever any of the dropdowns change.
- Show Search: Show the search bar to enable users to search for specific hierarchy members. This applies to all dropdowns.