Forum Discussion

swilder's avatar
swilder
Regular Visitor
4 years ago

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 ...
Need Help
Tips and Tricks
Tutorial Requests
PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
4 years ago

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's avatar
    swilder
    Regular Visitor
    4 years ago

    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's avatar
      PaulDBrown
      Icon for Community Champion rankCommunity Champion
      4 years ago

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

      • swilder's avatar
        swilder
        Regular Visitor
        4 years ago

        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.