Slicer will not parse multiple many to one relationships

[TJesse]

I have a main table Z. 

I have 3 other tables A, B, and C each linked with a many to one relationship to table Z. 

I need to filter out the tables using data from table A. I create a slicer from table A. The slicer will filter out my data from table Z but it has no effect on tables B and C. 

I need to figure out a way for table A to filter table Z then have Z propegate the filter to table B and C. Any help would be appreciated.

[MFelix · Accepted solution]

Hi @TJesse,

you need to setuo the bidirection cross-filtering (check this link) in the site is also available a white paper with several additional aspects, but be carefull because when adding this bidirectionality the outcome of the measures and visuals may have a different impact then expected.

Regards,

MFelix

[TJesse]

@MFelix

Thank you! Made my day. Been staring at this for hours. All it took was a few button clicks to Turn on bidirection cross-filtering. smh

[MFelix]

Hi @TJesse,

Glad I could help however be carefull with the results you are achieving after activating this because the calculations are affected by that bidirection.

Regards,
MFelix