SMARTER Slicers = BETTER User Experience | Show Only What's Relevant in Your Slicers in Power BI

In this video I show you how to make smarter slicers that show what is relevant for a better user experience. I walk you through different examples of how to set up the slicer interactions. From how to only show the top 3 items in a slicer to how to adjust the timeline slicer period based on the selection of a different slicer. I hope you find it useful.
Enjoy the video and subscribe for more Power BI tricks!

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

---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
00:00 Intro
00:57 Slicers interactions - fields from the same table
02:36 Slicers interactions - fields from different tables
03:55 Solving it with bi-directional filters
05:12 Solving it with a visual filter on the slicers
07:40 How to deal with selected items that shouldn't show
10:48 Return the TopN items in the slicer
12:27 Adjust the timeline slicer based on selection different slicer
19:33 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

[workstuff]

Nice video as usual! Personally I think this should be a native feature that could be configured without a work around.

[kirinde]

Dear Bas, your videos and teaching style is impressive. Love the way you break down things. All the best and wishing you all the success in everything you do.

[LeighRadmore]

Bas, I bow to you - you do amazing work and put out even better content. Any chance of you doing problem solving livestreams? showcase your talents in real time?

[ynwtint]

Another level of combo slicer and visual filter. Great. thanks.

[rasiksawant]

Thanks a lot, Bas, This video was literally a savior for me.

[richardmartin]

You are awesome. Clear and logical explanations. Great for filling in the gaps between DNA enterprise and sqlbi.

[royiz]

Great video!
I’ve implemented the dynamic dates slicer by assigning min and max transactions dates values in the min and max fields of the visual itself (there is a special setting for it)

[VipinThakur]

Nice video and very useful. please, Please use the full screen of Power Bi. That would be BETTER Viewer Experience.

[Platonov_Ilya]

Великолепно! Ты красавчик! Сильно помог в части связи фильтров!

[PedroCabraldaCamara]

such a great content. Amazing the simplicity you do it all. Thank you so much Bas

[BitTeluguGaming]

Thank u so so so much you solved a error which killing me from last 2 weeks. I'm now ur subscriber. 🙏🙏🙏🙏🙏

[akshaynikam]

It's fascinating. Thank you for this wonderful video 💕

[zvikabar-kochva]

Hello Bass, first, thanks for the video. I generally like your videos very much, but in this one I did find a flaw with respect to the range slicer. I downloaded the original file to check it out but I got exactly the same behaviour in my own dashboard. It turns out the high slicer value is updated automatically as soon as the user update the company selection. However, the low slicer value doesn't follow suit. in fact, it stayed exactly where it was left for the previous selection. To update its value the user must manually bring the slider to a position inside the range of values, applicable to the new selection, and than take it back all the way down. Then, and only then, the lower slicer value is updated to the correct value. This behaviour may confuse many users!
Kindly be aware.

[alexkim]

Thanks a lot, Bas. Just a small digression on this bi-direction with a 1-to-1 cardinality; would you agree that ideally it should be merged into a single table? I'd like to hear your opinion on this as I try avoiding bi-direction, and almost always have never used a 1-to-1 cardinality in my data model.

[shawnebrown]

Came across your channel recently. Fantastic!

[marcoB_]

Thanks a lot! Is it possible to similarly make the filters in the filter pane smarter so that for every field used as filter only values selected by (compatible with/relavant because of) other already applied filters show up as options ? thank you

[ChrisSmithFW]

Another great one! Thanks so much, Bas!

[fzm]

Awesome video! Thanks for this content 🤩

[kingsleyihemere]

Thank you for the quality tutorials you make.
I have benefited greatly from them.

Please I have this question, what do I do when I have Blank in Visual but there is No Blank in that table column?

[prachijain]

Hi Bas, Is there anyway we can use measure value on x axis?