Forum Discussion
Remove Slicer Selection using DAX
Hello all,
I have a question regarding the slicer and its selection, let's say I have a Product Category and Product item. Each Product has a number of items. If I have a slicer in both of them, then I can filter the Product Items according to Product Category.
The problem arises not when we change the value of the slicer on the Product category when an item is selected on the Product Item slicer. It always shows blank on all the visualizations.
We could remove all the filters using the bookmark button or (Clear all slicers) now as of 2023 but can we create a Dax to clear all the filters on the slicers?? I want all the filters (maybe on a column or a table) to clear (be it on a slicer or any other table) when a user selects a new value on the slicer.
Hi,
Unfortunately, this isn't currently possible, the only way to do this would be with the bookmark button as you mentioned. I think there was an idea around this on the ideas forum that you can vote for.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
1 Reply
Hi,
Unfortunately, this isn't currently possible, the only way to do this would be with the bookmark button as you mentioned. I think there was an idea around this on the ideas forum that you can vote for.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍