Search Bar in Power BI Slicer

search bar in Power BI slicer

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.

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 Rad on FacebookReza Rad on LinkedinReza Rad on TwitterReza Rad on Youtube
Reza Rad
Trainer, Consultant, Mentor
Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 20 years’ experience in data analysis, BI, databases, programming, and development mostly on Microsoft technologies. He is a Microsoft Data Platform MVP for nine continuous years (from 2011 till now) for his dedication in Microsoft BI. Reza is an active blogger and co-founder of RADACAD. Reza is also co-founder and co-organizer of Difinity conference in New Zealand.
His articles on different aspects of technologies, especially on MS BI, can be found on his blog: https://radacad.com/blog.
He wrote some books on MS SQL BI and also is writing some others, He was also an active member on online technical forums such as MSDN and Experts-Exchange, and was a moderator of MSDN SQL Server forums, and is an MCP, MCSE, and MCITP of BI. He is the leader of the New Zealand Business Intelligence users group. He is also the author of very popular book Power BI from Rookie to Rock Star, which is free with more than 1700 pages of content and the Power BI Pro Architecture published by Apress.
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.

Leave a Reply