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!
Download file here datatraining.io/powerbi-how-to
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powe...
Power BI Essentials datatraining.io/powerbilearni...
Business User Training datatraining.io/powerbi-busin...
For Custom Trainings and Consulting email directly [e-mail]
---------------------------------
⏱️ 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 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO​
Insta / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / howtopowerbi
Threads www.threads.net/@howtopowerbi
Newsletter datatraining.io/newsletter
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos www.epidemicsound.com/referra...
🚀 For growing on KZbin: www.tubebuddy.com/bas
🏄 Stuff I use daily amzn.to/3HqfMQ2
* 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

[@ynwtint]

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

[@richardmartin7904]

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

[@PedroCabraldaCamara]

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

[@royiz21]

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)

[@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?

[@rasiksawant7491]

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

[@shawnebrown]

Came across your channel recently. Fantastic!

[@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.

[@HowtoPowerBI]

Thank you very much Bhanuka!!! 🙏👍 all the best to you too!

[@kingsleyihemere6121]

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?

[@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

[@workstuff5253]

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

[@Ninjaa320]

Coming from Tableau, it's shocking to me that it isn't a native feature. Was surprised to see learning how to do it is a 15 minute video instead of just two clicks

[@alexkim7270]

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.

[@fzm280579]

Awesome video! Thanks for this content 🤩

[@BrianGarside]

Love this. Im working on a way to create Top level slicer to activate different groups of a Slicers with same functionality you showed in this video to show/Hide vs 1+groups. Is there a way to do that?

[@prachijain5955]

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

[@sixtyfiveroses2968]

Awesome as always. Thank you.

[@TrassBI]

Very useful video👍Thanks🙂

[@damiankrasniewski1354]

Hi! Thanks for the content. Can you tell me if it is possible to filter multiple values ​​at once? Let's say we have 100 products, but we want to take a closer look at only 10 of them, I have to filter them one by one, is there any possibility to copy the list of products I am interested in (e.g. from Excel) and paste the products in some filter?

[@andrewdutch4843]

Great video Bas - can I re-order chiclet slicers? I have years ascending but I need them descending, can this be done???

[@vijaykrishnan4151]

Hi Bas, I am not getting the issue you explained @ 8.03 . When Coffee Machine is selected, the Store Amsterdam is not showing in the Store Name slicer. Seems like it working is that it should be or is there something I am missing? I have the latest Nov'21 PBI update. Please note I have not used the custom Hierarchy filter. Kindly advise.

[@mcnater]

awesome vid...thanks

[@AmitSingh-er3lk]

i have two different column for start and end date for filter end date should be greater than start date in the selection , how can i achieve that, please suggest.

[@Platonov_Ilya]

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

[@HowtoPowerBI]

большое спасибо за просмотр

[@raghukumar4483]

Thank you. but how to show only those values in the slicer which have data when the slicer is in sync in other tabs. The other tabs have same slicer but the fact data is coming from different fact tables. Could please help me with this

[@SaltyVcp]

How would you implement this if the filter is used on different pages and needs a different measure to filter the other slicers? As far as I know you can't apply measure to filter on page so I am quite stuck in this predicament. The customer would like all slicers to sync over the pages but need to use different slicer filters cause the underlying fact table is changing...

[@akshaynikam6628]

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

[@HowtoPowerBI]

glad you enjoyed it - thx Akshay!

[@druthorah]

Excellent video

[@64BitTeluguGaming]

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

[@HowtoPowerBI]

thank you so much for the sub! - happy to hear the video helped you

[@VipinThakur]

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

[@HowtoPowerBI]

Thanks for the feedback Vipin

[@analisecritica8722]

Hello, how to select only one option in two different filters? example: In Filttro 1 it has the options (A, B ,C) and in Filttro 2 it has the options (D,E,F). So, how to select only 1 option among all options (A,B,C,D,E,F)?

[@marcing3364]

I was creating similar solution and found one bug, when you will select Company A then time range slicer will be adjusted (showing first date in left box and last date in right box for Company A), then when you will change date in left box to another day and then you will change Company A to B, then left box of time range slicer will still kept what you set for Company A, right box will change for last date for Company B), there was no reset function when user changed something in time range slicer. Did you also face this bug ? in 19:28 of this vid there is a momemnt with 3 companies selected and left date box is set to 12/04/2021, please check what will happen if you then will click on Company D, I bet left date box will still keep 12/04/2021

[@ChrisSmithFW]

Another great one! Thanks so much, Bas!

[@HowtoPowerBI]

:):) glad you like it Chris!

[@bitips]

Thks Bas , 👍

[@RavinderKumar-gl8cy]

Sir, How we can do the function similar to Indirect function in Excel, in power BI. For Ex. I am having a slicer with the name of all Indian states, If I don't select any thing from slicer, then in the table for ROW value , name of state should come and their population will come from measure. If I select any state from slicer , then in the table, respective district list should appear and there population. Please advise how we can do this.

[@sibusisomani1746]

Interesting!

[@shivamtyagi7779]

Great Video

[@HowtoPowerBI]

thank you Shivam!! 😀😊

[@lucascobb3515]

Have been stuck on the last filter type you showed with having a date range only show dates associated with data. I have a report with data up to March of this year, but the export of said data is delayed at least a Month or Two so when I finally update it, I get blank months showing. Note that there are multiple pages on my report with many many Fields so I wouldn't be able to make a slicer filter for all of them, so my thought is to adjust the formula used to generate the dates in a table. Could you possibly make a video showing what a date formula would look like that continued to add dates via a year/month when new data was imported, but not include blank months when data is delayed?

[@tehnokarzuan]

so did you make it work?

[@josefedericopresno6668]

Superlike to this video

[@ErickNishimoto]

Awesome 👏

[@HowtoPowerBI]

Thx Erick!!! 👊😎

[@user-wx3dn3il2f]

oh my god!! perfect

[@RuiCaio]

Why don’t you keep relationships unidirectional and add the measure [Total Sales] to each slicer filter (is not blank). That keeps your model without bidirectional relationships.

[@HowtoPowerBI]

I do 😉 just watch a bit further