Using Slicer

[kpan8]

I have 2 slicer. They are related to one another. One slicer have a yes and No selection as a flag. I would like to set the condition if the flag is set as Yes, then the other slicer will show "Select All".

[Anonymous · Accepted solution]

Hi @Ritaf1983 ,thank you for the quick reply.

Hi @kpan8 ,

Regarding your question, Power BI Desktop may not currently support dynamic visibility or conditional selection logic in a slicer based solely on the selection of another slicer. Perhaps you can combine bookmarks and buttons to accomplish your needs indirectly, as detailed below.
1. Select 'Yes' in the slicer, then manually select all options in the other slicer, and finally create a bookmark.

2. Create buttons and associate with bookmarks

3. Final output

More can be found in the following articles.

Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Learn

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

[Ritaf1983]

Hi @kpan8 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523