Power BI One Slicer to filter other slicers based on Items that has value only without BI Direction 

This is the solution I've been looking for for several days. Thank you very much!

Great. Have been looking at several solutions avoiding two-way filtering in the relation. This is the best and simple solution. Thanks.

Such a simple solution. Thank you. I spent last 4 hours trying to write complicated solutions to problem that I've created.

Simple and exactly what I needed. Thanks!

Thank you so much for clarifying this concept! You saved my report!

I am searched a lot for this and dropped but now i am happy thank you....

Awesome simple solution. Works like a charm!

Thank you! I was looking for something like that.

This helped me today. Thank you!

This worked perfectly - thank you!

Awesome, Thanks Reza, Right to the point I had spent over a day trying to figure this out and the solution you provided was very concise and right to the point.

Could not appreciate more. Thank you so much

I was looking for this thank you very much

Perfect! Thank you!

thanksss man you're awesome. love the simple idea but very impactful!!!

Thank you, really awesome

Great stuff sir! Thank you!

Thank you for sharing this!

Yes, exactly what I needed. Thanks

Great, very helpful

Superb, this is really useful thank you.

thank you very much for this video. It is perfectly working for me 🙂

Thank you, thank you, thank you.

Hi, thanks for your tutorial. I have a similar situation but I have also a date slicer. How can I make this work taking into account also a data range period? For example if a customer has a net amount in a range of time and not in another, how can I hide him when he has no amount?

Thank you man saved me :)

That's awesome, thank you

Worked. Thank you.

It helped me a lot......

Thank you so much !! :)

THANK YOU! 👍👍👍

Great thank you. Just curious - why this can't be the default behaviour for all visuals?

this is an excellent solution, have a quick question related to this, i have a state dimension and product dimension . One slicer belongs to state and another slicer belongs to product. Based on these two slicers the who visuals are interacting with the report. How should i write a measure for those dimensions ?

Thanks for this.. is there anyway to do this with the native filter pane?

With this method, you show the possible options in the 2nd slicer. Is there also an option, when I select an option in slicer 1, also 1 option is selected in slicer 2?

If i have 2 fact tables connected to 1 dimension table, then do i need to create 2 measures one on each fact table and add those 2 measures on Dim slicer filter?

Great article. Do you know if could be possible filter both slices based on a selection in the Table visual?

This is absolutely fantastic. However I had no option but to use bi-directional option in my report and is working fairly well

can we replicate the table selection to slicer?

Will this work for Select all option for second filter?

Want to know why have you created sum measure like this ? If suppose we are not having sales column in our table rather than we have some dimension table column with customer name and product how can we achieve the slicer filtering?

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

Thanks for the great video! But there seems to be a bug, that is when you change the fullname slicer, the selected value of product name slicer will not change until you manually change it. Is there any way for a walkaround?

Thanks for the solution... it does its purpose. I have some questions: can I use the bi-directional cross--filter in any relationship? like 1:* or *:*; Wouldn't this impact the performance of the dashboards? Or is it something that happens if the dashboard and the dataset are huge?

Why did yo use calculate in the measure? It works the same as a simple sum.

What if there are no measures used,what can be alternative way

It's work..I have variance column where I have created Dax .Hence selected criateria not blank cell .it's work while on the session once I re open BI dash..the filter is not working...can you please help

My filter screen is not like yours and I have the latest June 2021. I can't get your solution to work. I like it--but it won't work for me.

Thank You, Can you please share the link to download the database and try to check from our end.

Thanks for the great tip. Can you please also make a video for date range slicer selection, so i have company name slicer and date range slicer and I want to start the date when the selected company signed up, how can I do that? I have multiple companies with different sign up date and i have to use date range slicer

If my sales have negative and blank value then how to write condition

Cool ! But it is not working when the slicer (over a data with int type) has a "Between", "less than" or "greater than" ascpect. In the dropdown and list aspect it is working fine... Do you know if it's some bug?

Hello. Do you know how the connect powerbi to Google sheets and have a strong connection in which refresh doesn't have errors.

How would you do this for a report where you have multiple fact tables and multiple dimension tables with relationship to the fact tables?

Hi Team, i am watching your videos, thanks for sharing the same, i have a query - hope you could solve the same for me... Query : two different slicers on Country, Measure 1 = Sales value in Country A (from Slicer 1), Measure 2 = Sales value in Country B (from Slicer 2) , Measure 3 = Variance between Measure 1 & 2, but i am not getting the correct output, can you please help me to fix it. Thanks

what if there are more than one measures ??

Cool technique, with the consequence that the slicers will show only values present in the fact table.

its not working when you have a blank.. When a filter contains blank also with other categories, all the other categories are hidden and the filter shows only blank. Please Help!!!!

"One Slicer to filter them all" 💍

How were you handling such situations when you could not add filters to slicers?

I like it, but now you can never see the full list of products right?

Wheres the download?

Will it works for Snowflake schema...?