Search box missing for Integer SQL Table Slicer in Power BI Desktop

[stack23]

I Created a SQL Table with integers. When I tried to create a Slicer, and conduct for a single id, the search button does not show.

However, it will show for varchar columns, etc.

Did they remove the search functionality for integers??

 

[v-yuta-msft · Accepted solution]

Hi stack23,

Yes, I can reproduce this. And I can't find any information from official documentation:https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers. As a workaround, you can drag your column into visual level filter and then click advanced filter-> select "is"-> input the interger you want to search.

Regards,

Jimmy Tao