Toby on 17 Feb 2019 04:13:35
Allow one or both of the following:
Allow a selection on a "master/main" slicer to clear selections on all other slicers. For example, selecting a value in a "Category" slicer would clear the selections in the "Subcategory" and "Sub subcategory" slicers.
Allow a parent/child relationship between slicers such that changing the parent slicer selection automatically clears the child slicer selection
When slicers have a hierarchical relationship (e.g. Category slicer, Subcategory slicer, Sub subcategory slicer, etc.), current behavior is confusing for users:
If relationship cross filter direction is single, changing a parent selection filters the child slicers but leaves the previous (on no longer applicable) child selections listed in their respective slicers. In addition, zero results are shown in the downstream report visualizations (e.g. a table showing the results of the slicer selections). The user has to clear all of the child selections first to drill-down again.
If relationship cross filter direction is both, selecting subcategory filters category list. User has to clear subcategory selection to change category selection. The further down the hierarchy, the more clears up the hierarchy you have to make to change the top of the hierarchy selection.
- Comments (4)
RE: Selecting slicer value clears all other slicer selections
Infact I have this requirement. Clear the child slicer selections based on the Parent slicer selected.
RE: Selecting slicer value clears all other slicer selections
We have this problem on a report with 2 slicers on 2 fields (models under a brand) in the same table.
RE: Selecting slicer value clears all other slicer selections
Same functionality for the new filter pane would be very handy!
RE: Selecting slicer value clears all other slicer selections
agree. interesting that there is only one person that is requesting this. if there is another idea already with more votes please tell us.