Forum Discussion
Slicer selection
I have multiple slicers for Example :
Date
Country
Product Category
Now if i select the date slicer it should only reflect the data which is selected in the date field when i select the next slicer, the date slicer should clear all the filters and now i want the data to be reflecting only which is selected in the country slicer.
Normally the data is getting filtered as per both the slicers which i don't want, only want the data for whichever
slicer i select
Thank you in advance it would be a great help for me
Hi Anonymous ,
As a workaround, you could create a bookmark button to reset the slicers.
Reference:Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Docs
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Unfortunately currently slicers do not automagically get deselected when you select a different slicer.
Add a measure that count the rows of the table to the visual level filters of the slicer you want to change based on a selection on the other slicer. This way the affected slicers will only show the values that have corresponding data in the table
Hi Anonymous ,
As a workaround, you could create a bookmark button to reset the slicers.
Reference:Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Docs
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
