cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Adiuser Frequent Visitor
Frequent Visitor

Search text within drop down filter

Hi All , We have a slicer for a report on country/cities . We want to be able to give user the option to enter few letters of the city/country filter so they can quickly locate it rather than scrolling all the way down for a slicer with 30-40 values. Ex- If user wants to locate city - 'Zurich' he will have to scroll down a long list to check on the city. Rather on typing 'zu' in the same filter zurich should filter out . Is this possible? I checked on 'text Filter' but that will not give a dropdown list , I want both - A search within a drop down list as the list is too long. Thanks In Advance.
1 ACCEPTED SOLUTION

Accepted Solutions
alexei7 Member
Member

Re: Search text within drop down filter

Hi Adiuser,

 

Yes, you can do this within the Slicer visual.

 

If you click the elipsis (three dots) in the top-right corner, you'll get a menu to search and you can do exactly what you're asking.

 

Slicer.PNG

 

Thanks

Alex

View solution in original post

4 REPLIES 4
alexei7 Member
Member

Re: Search text within drop down filter

Hi Adiuser,

 

Yes, you can do this within the Slicer visual.

 

If you click the elipsis (three dots) in the top-right corner, you'll get a menu to search and you can do exactly what you're asking.

 

Slicer.PNG

 

Thanks

Alex

View solution in original post

Highlighted
Adiuser Frequent Visitor
Frequent Visitor

Re: Search text within drop down filter

Awesome , It works!! Thank you .
ignas Member
Member

Re: Search text within drop down filter

Do you know if it is possible to change the background color of the search?

@alexei7 @Adiuser 

kalyan209 Frequent Visitor
Frequent Visitor

Re: Search text within drop down filter

Hi 

can this be done for numeric value filters as

123456

645355

543423

989877

 

I tried applying the same method and it does not show up. 

 

Thanks in advance

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)