We have all had instances where we use a slicer in our data, but get frustrated because it does not get filtered to the appropriate data based on other filters.
Example - my datasource includes 30 sales people, but only 10 should show in the slicer for the dates I have selected.
I have seen a variety of solutions for this, including bi-directional filters on the two tables (Sales and Salesperson).
But in this video from BI Elite, Parker shows a very elegant solution.
Now, the point of this video is actually to show how to slice data based on the results of the Total Sales measure (which is an interesting trick as well) - but at the 6:41 mark, he then filters the disconnected slicer table to show only relevant data based on the visual. This is done with a virtual table. Really cool trick and I’m going to need to add to some of my existing reports.