Forum Discussion

prj102's avatar
prj102
Icon for Helper I rankHelper I
8 years ago
Solved

Search box missing from Slicer in Power BI Desktop

For some reason I can't figure out how to enable the search box in a Slicer.  I've tried data that had more that 80k record and as little as 50.  Nothing seems to work.  Am I missing something?  Is there a flag or switch I need to flip?

 

thanks,

  • Anonymous's avatar
    Anonymous
    8 years ago

    Hello, 

     

    in what data type is your data you wish to put in the slicer? As far as I see, you can only enable search for a text type column. 
    Then you should click at the ... (3 dots) at the upper right corner of the slicer and you will find the option to enable search

    Hope I could help!

     

    Regard,

     

    Barna

18 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hello, 

     

    in what data type is your data you wish to put in the slicer? As far as I see, you can only enable search for a text type column. 
    Then you should click at the ... (3 dots) at the upper right corner of the slicer and you will find the option to enable search

    Hope I could help!

     

    Regard,

     

    Barna

    • prj102's avatar
      prj102
      Icon for Helper I rankHelper I
      8 years ago

      So......   I checked the 3 dots after I posted and saw the "Search" option  :smileylol:

       

      Thanks for the help!

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        I can't find it out any clue?

        Thanks a lot

        Pierluigi

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Then you should click at the ... (3 dots) at the upper right corner  lower right corner of the slicer 

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Finally found it. Microsoft should make it easier for people to know how to search text in slicers.

    • MCornish's avatar
      MCornish
      Icon for Responsive Resident rankResponsive Resident
      7 years ago

      That is one one the most hidden features in this program. Along side the conditional formatting that only appears when you hover over it

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Here is also an other option which is super quick: Just select the slicer and hit ctrl + F : the search bar will appear.

    This worked for me since the three dots are not available any more in the newest Power BI version. It says "This setting has moved. tochange the slicer style, select Format > Slicher settings > Options > Style". But there is no option to turn on the search there.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hello, my issue is somehow related to this thread: i want to be able to type the text i want to filter the data on in the slicer. is there an option in Slicer to do so?

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Anonymous 
      you can't do that in the Slicer visual but there is a custom visual called "Text Filter". That should have to be good for your issue.

  • MarvinGallo's avatar
    MarvinGallo
    Frequent Visitor
    7 years ago

    Has anyone figured out a way to do a search with numerical values?

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I have a work around.  I went into the query, and duplicated the numerical column, and then transformed that duplicate column to type text.  Then use that duplicate column as the field in the slicer, and as prior posters mentioned, click the 3 ...'s on the slicer (top or bottom corner) and enable search.

       

      It seems silly that we can't search non-text fields though... <cough cough PBI dev team...>

  • Vilklop's avatar
    Vilklop
    New Member
    1 year ago

    I have the same issue, mine is a text type and when I click on the 3 dots, the search button option doesn't come up for me.