Forum Discussion
One Slicer to Filter Two Sheets' Visuals?
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 ...
PaulDBrown
Community Champion
Community ChampionWhich field is the slicer from and how is the model set up?
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.