Forum Discussion
stack23
7 years agoAdvocate II
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 t...
- 7 years ago
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
v-yuta-msft
7 years agoCommunity Support
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