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

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

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

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.

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

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)?

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?

Another great one! Thanks so much, Bas!

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

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?

Superlike to this video

oh my god!! perfect

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

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.

Excellent video

Awesome video! Thanks for this content 🤩

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

Came across your channel recently. Fantastic!

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

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?

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

Very useful video👍Thanks🙂

awesome vid...thanks

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

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.

Awesome as always. Thank you.

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?

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

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?

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

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.

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

Interesting!

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

Thks Bas , 👍

Great Video

Awesome 👏

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.