Forum Discussion
Filter 2 Visuals with a single slicers
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
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
1 Reply
- amitchandak
Super User
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