Create interactive slicer

[Anonymous]

Hello, I'm new to PowerBI and wasn't quite sure what to look for when looking for a solution to this problem. So feel free to point me in the right direction in case this question has already been answered before.

Lets take some sample data to illustrate my question:

Product	Category
1	Cat.A
2	Cat.A
3	Cat.A
4	Cat.B
5	Cat.B
6	Cat.B

Given this, I want to have two slicers at the top of my dashboard. One to select whether a user wishes to filter on specific products or categories. And the second one to actually make the selection. The items in the second slicer should change based on the selection made in the first slicer.

Thank you!

[Anonymous]

Hello @SSchepers ,

In my test, you need to create two other tables for slicers, then use the following formula:

Measure =
SWITCH (
    SELECTEDVALUE ( 'Slicer options'[Wish to filter?] ),
    "Yes", IF ( MAX ( 'Table'[Product] ) IN ALLSELECTED ( 'forSlicer'[Product] ), 1 ),
    "No", 1
)

After applying the measurement to the filter panel (set "is 1"), My display looks like this:

Here's the pbix file.

Have I answered your question? Please mark my answer as a solution. Thanks a lot.
If not, load some insensitive data samples and expected output.

Best regards
Eyelyn Qin

[amitchandak]

@Anonymous , there can be few ways to get that. See bookmark and button can help

https://www.youtube.com/watch?v=z9jdkyyE3WU

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive