cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Shelley Member
Member

Search function doesn't seem to work with a drop-down formatted slicer?

I've added a slicer to my report file and formatted it as a drop-down list. When I click on the search function, nothing happens. If I change the slicer to list format, then the search feature works. Does the search feature not work with the drop-down list format by design or is this a bug? It would be nice if it worked. Thanks for any help.

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: Search function doesn't seem to work with a drop-down formatted slicer?

@Shelley,

Make sure that you are using the latest version of Power BI Desktop(2.47.4766.801).

After you format the slicer as a dropdown, and click on the three dots and then search, you need to expand “ALL” as shown in the screenshot below, then magnifying glass will appear and you are able to search value.
1.PNG2.PNG

Regards,

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 REPLIES 5
Super User
Super User

Re: Search function doesn't seem to work with a drop-down formatted slicer?

@Shelley which slicer are you referring to the default one in power bi?  the only  slicer i know that works where you can type text in this one

 

https://store.office.com/en-us/app.aspx?assetid=WA104380859&sourcecorrid=819c3cd1-ce5f-4d01-9bf5-817...

 

but i might be wrong!


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
Shelley Member
Member

Re: Search function doesn't seem to work with a drop-down formatted slicer?

@vanessafvg Yes, the standard slicer in Power BI.

 

If you click on the three dots in the upper right corner and then click search,

Capture2.PNG

Power BI brings up a magnifying glass entry field like this:

Capture.PNG

When I format the slicer as a dropdoiwn, and click on the three dots and then search, nothing happens.

Super User
Super User

Re: Search function doesn't seem to work with a drop-down formatted slicer?

@Shelley ah yes, see that now,mine is working

 

do you have a lot of data maybe, could be performance?  


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
Moderator v-yuezhe-msft
Moderator

Re: Search function doesn't seem to work with a drop-down formatted slicer?

@Shelley,

Make sure that you are using the latest version of Power BI Desktop(2.47.4766.801).

After you format the slicer as a dropdown, and click on the three dots and then search, you need to expand “ALL” as shown in the screenshot below, then magnifying glass will appear and you are able to search value.
1.PNG2.PNG

Regards,

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Shelley Member
Member

Re: Search function doesn't seem to work with a drop-down formatted slicer?

@v-yuezhe-msft Thanks, that did it. It works now. I thought I was on the latest version as I downloaded earlier this month.