If you have too many items in a slicer, such as the list of customer names, or product names, then finding one amongst the list takes time, unless you enable the search. Fortunately, the search is there for you, you just need to enable it, In this very short article and video, I’ll explain where it is and how you can enable it.
Power BI Slicer without the search option
If you create a slicer in Power BI for a text value (such as the name of customers), the slicer looks like below without any search options.
It can be time-consuming for the user to scroll down to be able to find a customer in the list if the list is too big. The search bar would be necessary to have here.
Enable the search bar
Fortunately, the search bar is there. You just need to enable it. Click on the ellipsis on the right top corner of the slicer visual, and then you will see Search. Click on search.
This adds a search bar on the top of the slicer
The search bar added will stay there in the slicer, unless you disable it. Disabling it is similar to enabling it, which is to click on (…) ellipsis for more options and then click on Search.
This means if you want the search bar to be available for the end-users, then you have to enable it, and then publish the report to the Power BI service.
Study more: Slicers
I hope this quick tip helps you have a better Power BI visualization.
- If you want to learn how to change the multi-select slicer in Power BI as a further study, read my article here.
- If you are interested to create a slicer with the first characters of the text, read my other article here.
- To learn about Sync slicers in Power BI, read Leila’s article here.
- Relative date slicer can be helpful to learn about from my article here.
- You can implement a from-to date slicers using the method I explained in here.
- Relative date slicer for your timezone can be studied in my article here.
- I explained a method to create a clear all for slicers in Power BI here.
- To learn how one dimension can filter another dimension in the slicer, read my article here.