Auto "Clear Selections" for the second slicer

[vmakhija]

Hello

I have a report where I have slicers for "Category" and "SubCategory".

So, if I select a category in 1st slicer and then subcategory in 2nd slicer, I see the data.

Now when I select a different category in 1st slicer, my 2nd slicer still have the Subcategory from old category. How do I make my 2nd slicer to "clear all" itself if I change the Category.

Screenshots below -

Regards

[Anonymous]

I just came across the same issue.  The only thing I found was to download one of the slicer visuals.  The attribute slicer by microsoft seems to work.  I dont know why they dont fix the standard slicer.

[Wajeehuh]

Hi, can you explain how the "Attribute slicer' works for your case, I downloaded it and it behaves the same as the standard slicer.

[Myll]

It is your answer that should be marked as a solution ! Indeed, dowloading the Microsoft visual "Attibute slicer" solved the problem. Thanks a lot !

[Sebabes]

Seems like this still hasn't been officialy solved. The fastest and easiest solution I went for, was affing a "clear all slices button". I orignally thought about creating a boormark and use it in a button but then discovered there is an in built one that does exactly this, which I think was created exactly for this reason. Not the best solution, especially if you have multiple subcategories and want to mantain the first filter, but it works.