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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
ccfisher
New Member

Issues in Slicer with Filter turns off Select All

I have a Slicer which I filter on a text field.  Once I start typing in the field, the Select All is turned off.  I want to use the Select All with my filter.

Thanks.

Carolyn

1 ACCEPTED SOLUTION
Manoj_Nair
Solution Supplier
Solution Supplier

@ccfisher, Hi

 

In Power BI, when you start typing into the search box of a slicer to filter items, the slicer goes into a mode where it's filtering the list of items presented in the slicer itself, not the data in your report or dashboard. In this mode, the "Select All" option is not available because it wouldn't make sense to "select all" items based on a search filter that is designed to narrow down the list of items.

Essentially, using the search box in a slicer doesn't filter your data, it filters the items you see in the slicer. Once you've searched for and selected the items you want from the slicer, then it will apply that selection as a filter to your data.

This behavior is by design in Power BI,  there isn't a built-in feature to change this. If you often find yourself needing to select all items after filtering in a slicer, a possible workaround could be to clear the slicer's search box after finding and selecting the desired items. Once you clear the search box, the "Select All" option will become available again.

If this post helps to find solution would be happy if you could mark my post as a solution and give it a thumbs up

Best regards

Manoj Nair
Linkedin - https://www.linkedin.com/in/manoj-nair-%E2%98%81-344666104/

View solution in original post

1 REPLY 1
Manoj_Nair
Solution Supplier
Solution Supplier

@ccfisher, Hi

 

In Power BI, when you start typing into the search box of a slicer to filter items, the slicer goes into a mode where it's filtering the list of items presented in the slicer itself, not the data in your report or dashboard. In this mode, the "Select All" option is not available because it wouldn't make sense to "select all" items based on a search filter that is designed to narrow down the list of items.

Essentially, using the search box in a slicer doesn't filter your data, it filters the items you see in the slicer. Once you've searched for and selected the items you want from the slicer, then it will apply that selection as a filter to your data.

This behavior is by design in Power BI,  there isn't a built-in feature to change this. If you often find yourself needing to select all items after filtering in a slicer, a possible workaround could be to clear the slicer's search box after finding and selecting the desired items. Once you clear the search box, the "Select All" option will become available again.

If this post helps to find solution would be happy if you could mark my post as a solution and give it a thumbs up

Best regards

Manoj Nair
Linkedin - https://www.linkedin.com/in/manoj-nair-%E2%98%81-344666104/

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.