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

In a star schema design, how you can filter one dimension by another dimension. How you can find all the products that this customer purchased or all customers who have purchased this product using two separate slicers.
To learn more about star schema:
radacad.com/power-bi-basics-o...
To learn more about the direction of the relationship:
radacad.com/what-is-the-direc...

[@katarzynalaskowska4740]

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

[@mvanleewen13]

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

[@mikedbman]

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

[@nizamedakkara6783]

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

[@PallaviChauhan91]

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

[@ionascurazvan3980]

Awesome simple solution. Works like a charm!

[@RADACAD]

Glad it helped

[@zachariahvercruyssen5305]

Simple and exactly what I needed. Thanks!

[@mehranofff]

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.

[@RADACAD]

You're welcome!

[@pontakorn2000]

Could not appreciate more. Thank you so much

[@RADACAD]

Happy to help!

[@michaelscott877]

This worked perfectly - thank you!

[@rolim92]

Thank you! I was looking for something like that.

[@bintangazhari244]

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

[@Hydrarian]

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?

[@raraei]

This helped me today. Thank you!

[@TheAusafonly]

I was looking for this thank you very much

[@sathyaruba4405]

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

[@Patiencelad]

Great stuff sir! Thank you!

[@rabmaq]

Yes, exactly what I needed. Thanks

[@kemilherath3524]

Thank you for sharing this!

[@niluparupasinghe171]

Superb, this is really useful thank you.

[@kingingway3308]

Perfect! Thank you!

[@sqlservertutorialin3minute485]

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

[@shoman7205]

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?

[@karthikj9326]

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 ?

[@ntokozomsomi8816]

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

[@DreeKun]

Thank you, really awesome

[@nizamedakkara6783]

can we replicate the table selection to slicer?

[@lireshpy8189]

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?

[@saradachoudhury8732]

Will this work for Select all option for second filter?

[@ihebchafai2780]

Great, very helpful

[@franciscoisaacs881]

Thank you, thank you, thank you.

[@thinkngskeptic]

Worked. Thank you.

[@RADACAD]

Glad it helped

[@narenderreddy2070]

It helped me a lot......

[@danyhoter2240]

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

[@kunal0509]

Thank you man saved me :)

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

[@tadstar]

That's awesome, thank you

[@saketsrivastava84]

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?

[@tinashechinyati6823]

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

[@soumyamohapatra646]

Thank you so much !! :)

[@JoseMariaBetegon]

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

[@RADACAD]

That might need a both-directional relationship which is not recommended. another way is to use drill through to another page with the selection of slicers

[@swathik4911]

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

[@pritishah6035]

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

[@vipultyagi74]

what if there are more than one measures ??

[@poojagrpoojagr7236]

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

[@yangli6074]

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?

[@tonypetro4496]

I have the same issue. Would love a solution!

[@vijayjiya]

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

[@venkata3555]

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

[@RADACAD]

Here is the link: radacad.com/files/AdventureWorksDW2012.xlsx

[@eriksteven8462]

THANK YOU! 👍👍👍

[@aleena1549]

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

[@bhaveshgehani1872]

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

[@hzrasheed]

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

[@RADACAD]

I haven't used Google Sheets as a source, but there is definitely an issue that causes errors. what connection type you used?

[@user-on3wx7ce1p]

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?

[@RADACAD]

BI directional relationship impacts the performance even for small datasets, not recommended at all.

[@StephanOnisick]

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.

[@aswinlite]

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?

[@Hydrarian]

Hi, I have the same problem, have you found a solution?

[@awaismunir5377]

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

[@RADACAD]

There were different workarounds for that. calculated tables with subset of data was one of the methods previously I have used.

[@imhareeshmalluri]

​@@RADACAD Any article ? Can you please post link here ?? :) I have 7 slicers 9 Fact 200 Measures in my model, I was trying to this bi-directional but it is working for One Fact Table, While the same dimension connecting with another fact it will automatically create inactive , Oops :( i cant re-write all the measures by using USERELATIONSHIP, Could you please suggest the way to solve it

[@muhammadadnan6620]

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

[@Hydrarian]

Hi, I have the same problem, have you found a solution?

[@muhammadadnan6620]

@@Hydrarian Yes i have got but not a best solution I have selected cross filtration in both ways

[@1tsvaishnav]

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

[@RADACAD]

One of the methods was to use a calculated table with a subset of data. I have written a blog article about it previously.

[@GiovanniSpagnoli]

"One Slicer to filter them all" 💍

[@StephanOnisick]

Wheres the download?

[@adolfojsocorro]

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

[@RADACAD]

Yes. That is the point of this trick. Otherwise no visual level is needed.

[@adolfojsocorro]

@@RADACAD I mean, when nothing is selected anywhere the slicers show only existing values, not all values in the dimensions.

[@RADACAD]

@@adolfojsocorro yes. Because it is filtered to show values only when there is a value in the fact table. If you take our the visual level filter, then slicer shows all available values in the dimension anyway.

[@smartrose7997]

Will it works for Snowflake schema...?