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 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
5 Replies
PaulDBrownCommunity Champion
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)
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?
