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

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

Reply
Mark_Ball_25
New Member

Select All in Filter

Good day,

In the past (If i remember correctly), a User when using a filter in the filter pane, could start typing in the search box of a filter and the select all would be at the top so you could 'select all' remaning selections that you're search is narrowing down to. Or just call me crazy, maybe it never worked that way.

 

Example where it helps, I have a hundred sales offices in the US, i want to filter to each of our Texas ones (say 25 offices) and I type TX  in my sales office filter to narrow the search, then click select all so i don't have to tick off 25 times selecting each them.

 

Mark_Ball_25_0-1690575830884.png      Mark_Ball_25_1-1690575865022.png

 

Thank you,

Mark

 

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @Mark_Ball_25 

I am not aware of any previous differences in how the filters worked

(since 2017 working with the tool)

Please report it if you think it's a malfunction at the following link:

https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues

 

Somebody suggested it as an idea, so you can vote for it here (I voted for it now 🙂 ) :

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=8f3a98d1-a797-eb11-89ee-0003ff452f24

 

Meanwhile, I recommend collecting your categories into a group and subgroup, then allowing the group to filter the subgroup and reduce the list

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

2 REPLIES 2
Ritaf1983
Super User
Super User

Hi @Mark_Ball_25 

I am not aware of any previous differences in how the filters worked

(since 2017 working with the tool)

Please report it if you think it's a malfunction at the following link:

https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues

 

Somebody suggested it as an idea, so you can vote for it here (I voted for it now 🙂 ) :

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=8f3a98d1-a797-eb11-89ee-0003ff452f24

 

Meanwhile, I recommend collecting your categories into a group and subgroup, then allowing the group to filter the subgroup and reduce the list

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Thank you! I voted it up and asked colleagues to as well. Pretty low count, not going to hold my breath...lol.

Helpful resources

Announcements
May Power BI Update Carousel

Power BI Monthly Update - May 2026

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

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.