Filter 2 Visuals with a single slicers

[AbdurRahman]

Spoiler

Hi Friends,

I have two Tables :

            Table 1 & Table 2.

            These two tables joined with same column (Country) Table1 Country Joined with Table2 Country 

            Cardinality : Many To Many

            Cross Filter Direction : Both

I used Country field (from table1) in slicers and two different charts (table 1 & Table 2) measure are getting filters based on single Slicer.

Problem occured from here now :

I want have a another slicer with STATE FIELD when I add another Slicer with STATE , this slicer is not effecting the 2nd graph which is taken from Table 2. Its only working with Chart of Table1.

I would like to have 2nd slicer (state) should work for both the charts.

Please help.

Thanks

[amitchandak · Accepted solution]

@AbdurRahman , It is better to have few common/ Bridge tables like country, state, date etc and analyze data with help from those

https://www.seerinteractive.com/blog/join-many-many-power-bi/

Bridge Table: https://www.youtube.com/watch?v=Bkf35Roman8&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=19