Forum Discussion

shrmehta's avatar
shrmehta
Advocate IV
9 years ago
Solved

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

 

 

Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    shrmehta

     

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

     

    Regards,

22 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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.

     

     

  • spiskai's avatar
    spiskai
    Advocate I
    9 years ago

    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).

     

  • MarkCBB's avatar
    MarkCBB
    Helper V
    9 years ago

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

    • nlevin's avatar
      nlevin
      Frequent Visitor
      9 years ago

      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's avatar
    prabhupan
    Helper I
    9 years ago

    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. 

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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

    • shrmehta's avatar
      shrmehta
      Advocate IV
      9 years ago

      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

      • lemontree's avatar
        lemontree
        Helper I
        8 years ago

        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?