Using a cascading member filter control
A cascading member filter control displays each level of a hierarchy on separate dropdown controls. Each dropdown is filtered based on what is selected on the parent level dropdown.
Pre-requisites: You need to be using a hierarchy, either from an SSAS Cube, or for relational data - a hierarchy created from the Hierarchy designer. 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 Control
- Drop the measure and the hierarchy to the dashboard.
- From the toolbar, add a Cascading Member filter control.
- Bind 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 is set to true, the token menu will not be displayed on the parameter control.
- Manual Items: If enabled, the item(s) displayed in the control are manually controlled instead of auto-populated from any associated View Parameters. This is most useful when using this control with script instead of with a parameter.
- 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 controls being filtered by this cascading member filter will only filter when the last filter control gets a value. Enabling this option will cause the control to filter all connected controls whenever any of the filter controls change.
- Show Search: Show the search bar to enable users to search for specific hierarchy members. This applies to all hierarchy pickers.