Skip to main content

Power BI

New

Selecting slicer value clears all other slicer selections

Vote (15) Share
Toby's profile image

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)
Toby's profile image Profile Picture

688746e2 4767-4a7a-95d6-0db252f890c6 on 06 Jul 2020 00:15:29

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.

Toby's profile image Profile Picture

ed66c093 49cd-49fd-a93f-1a06fe9706e0 on 05 Jul 2020 23:53:28

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.

Toby's profile image Profile Picture

d95964ff 7cdd-4789-8f4f-549b3bf22de6 on 05 Jul 2020 23:44:43

RE: Selecting slicer value clears all other slicer selections

Same functionality for the new filter pane would be very handy!

Toby's profile image Profile Picture

b1a92dec c272-447d-be93-5e4edf07a60e on 05 Jul 2020 23:42:22

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.