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 t...
  • 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

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