One Slicer to Filter Two Sheets' Visuals?

[swilder]

I am seeking help on creating one slicer to filter visuals representing two seperate sheets. The two sheets have many of the same columns as shown below. I have already created relationships between similar columns.

When I create a vendor slicer, it will only apply to Table A's visuals, and not filter Table B's.  

Table A

Date	Vendor	Component	Inspection Points	Outcome	Lab
5/01/2022	Vendor1	123	4	Pass	LAB1
6/01/2022	Vendor2	234	8	Pass	LAB2

Table B

Date	Vendor	Component	Weight	Outcome	Lab
5/12/2022	Vendor2	123	8.6	Pass	LAB2
6/12/2022	Vendor1	234	7.7	Fail	LAB1

Here is an actual image of the visuals created. I am unable to get the vendor, date, or component filters to apply to both Lab Testing and Inspection visuals. How would this be achieved? Thank you

[PaulDBrown]

It sounds like you need to create dimension tables with unique values for each of the fields you are using as slicers. 
do you have some sample data or a link to a PBIX file (no confidential data)?

[PaulDBrown]

Are both visuals on the same page? If so, you can edit interactions between slicers and visuals by going into Format in the ribbon, select Edit Interactions, select the slicer and adjust the behaviour as you need for each visual (you can turn off hte interaction if you don't want a visual to be affected by a slicer)

[swilder]

Hello! Yes they are on the same page. I have made sure that the interaction is set for all visuals for each slicer, but the slicer still won't filter the second table's visuals. 

[PaulDBrown]

Which field is the slicer from and how is the model set up?

[swilder]

The slicer is based on the Inspection table's Vendor column. I have also tried basing the slicer on the Lab Testing table's Vendor column, with the same issues.

The Inspection table's Vendor column has a "many to many" relationship with Lab Testing table's vendor column. I receive an error anytime I attempt to edit the cardinality.  I have tried making it active and unactive.