Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Using Slicer Dropdown to See 'All' categories

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's avatar
    paliman
    6 years ago

    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

2 Replies

  • paliman's avatar
    paliman
    Frequent Visitor
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks Pablo, really appreciate it.