The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
55 | |
24 | |
14 | |
14 | |
12 |
User | Count |
---|---|
106 | |
39 | |
28 | |
22 | |
22 |