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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
shrmehta
Helper I
Helper I

Search Option in Slicer

 

I have enabled search in my slicers. However the search bar is not displayed in a few and partially displayed in a few others.

 

This error is only on Power BI Services and not on Power BI Desktop.

 

-Shruti

 Search.png

 

1 ACCEPTED SOLUTION

@shrmehta

 

We have reproduced this issue. It happens when dropdown list is long, just as you said. We have reported this issue internally.

 

Regards,

View solution in original post

22 REPLIES 22
Anonymous
Not applicable

Recurring issue. The Search (on dropdown) is not working in PBI Desktop (June release). Works for some of my slicers, but newly created ones no longer provide for searching.

 

The alternative was to use the Attribute Slicer.  Should the PBI slicer start working, I will look to revert. Unfortunately this results in inconsistent tools visualization across report pages.

 

For some dropdowns (1,000+ items) search works fine. For others (<500) does not work at all.

 

 

Anonymous
Not applicable

Issue not solved anymore (in fact the situation has worsened)

 

Now I can see the lens and the search box (using any kind of browser) but it's impossible to enter anything in the box.

 

Before this "fix" with Firefox were possible to use properly the search option in slicer

I tried it in Chrome, Firefox and IE for a list of almost 8000 and it works fine now. 

 

In Firefox and IE I could immediately type in my search words, however in Chrome, try to click in the search box near the magnifying glass, a smaller text box appears where you can type.

 

Untitled.png

 

Regards,

Shruti

I have the same issue and it must have to do with the size/length of the list. I received a sample pbix and it works fine and when i try to reproduce this on another (larger) dataset it breaks. I am using the latest version (oct 2017) of power bi desktop and chrome. any ideas how to resolve this? one potential solution until it is properly handled it would be to allow us to limit the selection list by a certain field e.g. total sales and apply advanced sorting and bring the top x % of items. anyone that has managed to make it work somehow?

MarkCBB
Helper V
Helper V

With large lists I get the problem with the Desktop application. 

I am still seeing this behaviour occur with certain dropdown lists (we are using DirectQuery against SSAS source).  It works for a long list  (more than 400 items) but some of the shorter ones do not work.   

prabhupan
Helper I
Helper I

Just wanted to add the search option works fine if we choose List instead of Dropdown in the slicer settings. However, it used to work for both in the previous version of Power BI. RQ.png

 

 

@ PK
spiskai
Frequent Visitor

I saw that this issue has been reproduced, but wanted to add that this is also occuring within Power BI Desktop (at least on many of my reports).

 

PavelR
Solution Specialist
Solution Specialist

@shrmehta

already discussed here.

 

Regards.

Pavel

Thanks @PavelR

 

-Shruti

@shrmehta

 

I haven't reproduced your issue.

 

13.PNG

 

We are still trying to figure out the reason. You may try Attribute Slicer currently.

 

Regards,

 

 

Anonymous
Not applicable

I confirm , I've faced the same issue in my reports. The problem appers when there is a long list (usually longer than the box) 

@v-sihou-msft

 

It happens when my dropdown list is long. I am facing this problem when I use Chrome or IE. In Firefox the search bar is visible. But since most of the users of my report use Chrome, I would prefer if I would be able to view the search bar in Chrome too.

@shrmehta

 

We have reproduced this issue. It happens when dropdown list is long, just as you said. We have reported this issue internally.

 

Regards,

Anonymous
Not applicable

@v-sihou-msft is this issue with slicer search option solved yet ?

I'm still having problems. Just not seeing the search box at all - in list or dropdown.

Anonymous
Not applicable

Dear @Debbie,  in the slicer at the top right hand corner click on "Search" now once you do that then click on the drop down, right below the drop down the option is there. see the pic below. combo.png

Ah. Got it in a list - but not in a dropdown! Better than nothing - thanks!

 

Debbie

Anonymous
Not applicable

did you do something different this time ? Just wondering Smiley Frustrated

Probably - without realising it! I'm still learning this tool .... 🙂

 

Debbie

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors