The ULTIMATE Slicer Panel in Power BI

In this video I walk you through how I would build the ultimate slicer panel. I show you how to integrate a bookmark navigator to deal with a large number of slicers and to bring structure. Then I have a closer look at how to visualise the applied filters and how we can highlight the slicers that have a filter in place.
Enjoy this video and subscribe to always stay updated on my favorite Power BI tricks :)

--------------------------------
📊 TRAININGS 📊
---------------------------------

---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
00:00 Intro
01:23 Formatting and organising the slicer panel
04:00 Using the bookmark navigator to deal with many slicers
07:52 Showing which filters are applied – Option 1
13:10 Showing which filters are applied – Option 2
18:43 Adding a reset filters button
21:28 Improving the design
30:12 Creating an indicator for slicers with an applied filter
35:56 End

---------------------------------
😍 JOIN 😍
----------------------------------

---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------

* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!

Thanks for being a part of this channel and all your support! 💪 🙏

#HowToPowerBI​ #PowerBI​ #DataTraining​
#powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX

[sukoi]

This is so much fun and next level thing. You are the "Bear Grylls" of Power BI, the way you consume every possible features in it. I bet not even the developer team behind ever thought of these tricks.

[kostaszogo]

This guy deserves more subscribers than Netflix and Disney+ combined...
Great video Bas, continue spreading that wisdom!

[RichardOliver]

I love the way you acknowledge the (current) product shortcomings but find a way to work round it. Very creative!

[peterg]

Love the solution to identify which filters are applied. That is such a clutch feature when you have a filter panel that is not visible by default. I was playing around with Option 2 a little bit, and I decided to go with something like this

ShowFilters3 =
"Filters (" &
IF (
ISFILTERED('Data'[Region]),
1, 0)

+

IF (
ISFILTERED('Data'[Property Type]),
1, 0
)
& ")"

If space is an issue, then dropping this measure as "Text" in a Button shows the user how many filters are applied, and they can click the button to show the Filter panel and make any changes.

[paulgallagher]

Thanks as Ever Bas! I've only used the Dax Studio DumpFilters feature for de-bugging before as I found it too cumbersome to use in a report. However I hadn't thought of editing the text and only using the sections I needed to make it production friendly before! This is a great addiiton to my filter panel.

I also love how you purposely make common mistakes to re-inforce our learning. Like you did with the 'Data' Bookmark Setting. 👍👍👍

[hius]

Bas continues to produce the absolute best Power BI content, just can't get enough from it and I thought I knew what I was doing. Keep up the great work!

[ozansen_ozibaba]

This is really high quality video about both design and filter context! As always, Good Job, Dear Bas!

[karthikprabhakar]

Just falling in love with all the manipulations and how ur fooling with the functionalities to bring the BEST of the BEST, just amazing, Brilliant! 💓💓💓💓💓

[Vittoria]

I watched the video and immediately implemented the idea in my Power BI report! Thank you!

[juliemillerwealthartificer]

FANTASTIC!!!! Thank you so much!!! I will definitely use this method going forward.

[EduardoCortezOrtega]

The world needs more content creators like you, thanks!

[carolpruett]

I am looking forward to using Bas' ideas in my slicer panels. This is definitely how to make your slicer panels look sleek while using the space on your report page more efficiently.

[kukeleku]

Great video! You make it look so easy but it's a really clever solution. Thanks for sharing!

[coreyayers]

Really Really well done! I am bingeing your videos! Love the easy to understand directions and your focus on things looking nice! Well done keep them coming!

[kayvonsadrabadi]

Thoroughly enjoy your knowledge and enthusiasm. Thank you for what you do! 🙏

[prabz]

This is great stuff Bas. Your style of
explaining things is so easy for anyone to understand. 👍👍👍

[christiangarza]

This is really amazing! I'm definitely using this on mi job. Thanks mate

[andreicostin]

U`re awesome with these quality videos that u`re still making weekly, love you job and Power Bi skills :D

[dsswooshy]

Brilliant video thanks.

My company uses Qlik and Power BI and well, let's just say as the Power BI developer, being able to develop the filter pane in Power BI is nice.

[ahmedalkherbi]

Awesome! I learned lots of things. Thank you very much.