How to reset power BI slicer when it is set to single select?

[Anonymous]

I have 2 slicers which contain selection controls as single select when i am selecting 1 slicer and its corresponding 2nd slicer is getting filter(which is as expected)but when i am again re-selecting 2nd item then earlier selection does not reset automatically.It is still present and i need to manully chnage my selection to other filtered record.

below is screenshot explaining my issue-

here we can see only 1 record present in slicer

now if i select some other option in "Sold to Name" earlier selected value is still present in "Ship to Name" slicer and table is showing blank due to that selection.

and if i now manually select the first record from "ship to Name" then old recod from earlier selection will get removed and table will show correct filtered value.

So is there any way to avoid this?

Please help!

[V-lianl-msft]

Hi @Anonymous ,

As @MFelix  said,you may try it.

If the slicer comes from two tables, you can set the filtering direction of the two tables to both.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MFelix]

Hi @Anonymous ,

This is the normal behaviour of the slicers since they are selected independently, when you clear one slicer the selection on the other slicer is not clean imeadatly.

You have two options:

• Place the two columns inside the same slicer making it a hierarchy slicer.
• Make a bookmark with the slicers clear and then associated them to a button.

[Anonymous]

i tried with heirarchy Slicer but it doesn't have dropdown.

[MFelix]

Hi @Anonymous ,

The hierachy slicer does not support the dropdown the maximum you can do is to close to the first level.

If this is a question about space on the page you can do the reset button with bookmark, or a bookmark that hides the slicer from the page.