Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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 SlicerCurrent Slicer

1 ACCEPTED SOLUTION
paliman
Frequent Visitor

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

View solution in original post

2 REPLIES 2
paliman
Frequent Visitor

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
Not applicable

Thanks Pablo, really appreciate it.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.