cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
natabird3
Continued Contributor
Continued Contributor

Search filter by entering text and select all afterwards - Possible?

Is it possbile to somehow add the select all once you filter for a particular text in the search option of filters:

example

1.JPG

I want to select now all /ent but there doesn't seems to be a way, any advice? 

 

Thanks in advance. 

2 ACCEPTED SOLUTIONS
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @natabird3 ,

By my test, you could achieve your requirement by the steps below.

1. Create the list slicer and turn on the "Select all " option under formatting.

2. Click Select all under the list and enter your search text in the search bar then you could get your expected ouptut.

Capture.PNG

Best Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

natabird3
Continued Contributor
Continued Contributor

Cherry, that did work but not really. Because if i select all and then search the select all is still applied on the remaining of the data (meaning is not filtering for what i am searching). So in the end i dont think the proposed solution worked sorry. Do you have any other advice? 

View solution in original post

8 REPLIES 8
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @natabird3 ,

By my test, you could achieve your requirement by the steps below.

1. Create the list slicer and turn on the "Select all " option under formatting.

2. Click Select all under the list and enter your search text in the search bar then you could get your expected ouptut.

Capture.PNG

Best Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Hello,

 

I still don't see a way to "Select All" the filtered values on a searched slicer.

 

1) If follow the "solution" in this thread, it doesn't work (without creating a second separate slicer).

- First,"Select All" in the slicer

- Second, use the "Search" function in the slicer to search for a substring.

RESULT: All KPI's & visuals remain unchanged.  Screenshot 1 shows KPI Value 1, Value 2 & Map item unchanged by slicer.

 

2) Notice that if an entirely different slicer is created for "State" (or another Search slicer), and value "TX" is selected, the KPI's & visuals immediately change.  (Screenshot 2). (However, it should not be necessary to create a second slicer in this situation.  It should be possible to select only the filtered list of slicer values within the searched slicer.)

 

Does anyone know if & when Microsoft plans to include this very basic BI slicer funcationality?

 

Thank you,

Nathan

 

 

 

WinterMist_0-1639174484868.png

 

WinterMist_1-1639175438387.png

 

 

Anonymous
Not applicable

 

 

I'm having the same issue as @natabird3.

 

Doing this shows me the results, but then doesn't filter the rest of the page, so I still need to go through and hold down CTRL selecting each one....

natabird3
Continued Contributor
Continued Contributor

Cherry, that did work but not really. Because if i select all and then search the select all is still applied on the remaining of the data (meaning is not filtering for what i am searching). So in the end i dont think the proposed solution worked sorry. Do you have any other advice? 

View solution in original post

natabird3
Continued Contributor
Continued Contributor

Thank you Cherry. I didnt realize that selecting all will work, as initilaly i was searching and then trying to select all however then the option was becoming not available. Thanks for the help now i can select all first and then search which works perfectly. 

Hi Natabird,

Did u get the solution. If Yes, Please let me know the solution.

natabird3
Continued Contributor
Continued Contributor

Unfortunately the only way is to select them one by one for the time being, select all doesnt work as suggested in the post.

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors