Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
Solved! Go to Solution.
We have reproduced this issue. It happens when dropdown list is long, just as you said. We have reported this issue internally.
Regards,
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.
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.
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?
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.
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.
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).
I haven't reproduced your issue.
We are still trying to figure out the reason. You may try Attribute Slicer currently.
Regards,
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)
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.
We have reproduced this issue. It happens when dropdown list is long, just as you said. We have reported this issue internally.
Regards,
I'm still having problems. Just not seeing the search box at all - in list or dropdown.
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.
Ah. Got it in a list - but not in a dropdown! Better than nothing - thanks!
Debbie
did you do something different this time ? Just wondering
Probably - without realising it! I'm still learning this tool .... 🙂
Debbie
User | Count |
---|---|
23 | |
21 | |
11 | |
11 | |
10 |
User | Count |
---|---|
49 | |
31 | |
20 | |
18 | |
15 |