Using Slicer Dropdown to See 'All' categories

[Anonymous]

Hello,

I currently have a slicer that lists products, and then a category for 'All.' When 'All' is selected, I need that the be the equivalent of having the other 4 products selected - essentially selecting 'All' would remove any other filter. How would I do this with a DAX query, or is there another better solution?

Thanks for the help!

Current Slicer

[paliman · Accepted solution]

Instead of having the value "All", select the list, go to the Visualizations pane in Power BI Desktop, click on the paint roller and under "Selection controls" activate "Show Select All Option"

Note: My Desktop is in spanish, so the menues may have a little different wording

Regards

Pablo

[Anonymous]

Thanks Pablo, really appreciate it.