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.
Video
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
Persistent Setting
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.
Reza is author of more than 14 books on Microsoft Business Intelligence, most of these books are published under Power BI category. Among these are books such as Power BI DAX Simplified, Pro Power BI Architecture, Power BI from Rookie to Rock Star, Power Query books series, Row-Level Security in Power BI and etc.
He is an International Speaker in Microsoft Ignite, Microsoft Business Applications Summit, Data Insight Summit, PASS Summit, SQL Saturday and SQL user groups. And He is a Microsoft Certified Trainer.
Reza’s passion is to help you find the best data solution, he is Data enthusiast.
His articles on different aspects of technologies, especially on MS BI, can be found on his blog: https://radacad.com/blog.
excellent
This option doesn’t exist in the list for me. There is no ‘search’