Forum Discussion
Search box missing for Integer SQL Table Slicer in Power BI Desktop
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??
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
1 Reply
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