I always am amazed that there is still so much to learn with Power BI.

This week’s blog post is short and sweet, I am going to demonstrate how to add searching to the Default Slicer in my Power BI Report.

The main reason that I required this, is because currently (14 Aug 2018) the persistent filters only works with the Out of the Box Slicers. I had a requirement to be able to search on my slicer items.

I added my slicer to my report and changed it to be a drop down

It then looked like the following below.

All I had to do to enable the search to work was to click on the ellipses (three buttons, burger dots etc) and click on Search

Now when I click on my Slicer items I get a search option.

I then search for my first name which returns the following below, which allows me to select my name and slice my report by my name.

How awesome is that! It was like finding a nugget of gold for me, something that was there all along, but never thought to use it in this way.

As always if you have any comments or suggestions please leave them in the section below.

2 thoughts on “Quick Tip Adding Search to the Default Slicer in my Power BI Report”

  1. Just note that if you turn the header off in your slicer, you cannot erase your search selection. The eraser is in the header, and it goes away if the header isn’t there.

    1. Hi Ed, thanks for the comment and yes you are 100% correct, I have had it previously with the Date Slicer if you remove the headers you do not get the drop down to change the types.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.