Quick Tip Adding Search to the Default Slicer in my Power BI Report
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.