topic Re: Using Slicer Dropdown to See 'All' categories in DAX Commands and Tips

Using Slicer Dropdown to See 'All' categories

Anonymous — Wed, 30 Oct 2019 18:08:46 GMT

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!

Re: Using Slicer Dropdown to See 'All' categories

paliman — Wed, 30 Oct 2019 18:39:24 GMT

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

Re: Using Slicer Dropdown to See 'All' categories

Anonymous — Wed, 30 Oct 2019 18:42:04 GMT

Thanks Pablo, really appreciate it.