Using Slicers

[Jmccoy]

I am using various slicers to make a report. I have a project status which contains where the project is in the bid stage, a project manager which is all the various project managers and then a slicer based on all the Sales reps we have. 

My sales rep slicer shows a long list of people that do not even have projects in the data. Is there a way to make the slicer change based on the other slicers. Ex. When I click on a project manager, it would eliminate all of the Sales reps that do not have any projects with that project manager. 

[VasTg]

@Jmccoy 

Is the Project manager and Sales rep from a same table? Is so it should filter automatically. Otherwise, you should have the filter direction set in the data model that should go from Project manager table to Sales rep table.

Also, check for visual intereaction is set to filter between the slicers.

If it helps, mark it as a solution

Kudos are nice too.

[Jmccoy]

Thanks for reaching out. I needed to manage the relationship and allow both directions on filtering.

[V-lianl-msft · Accepted solution]

Hi @Jmccoy ,

According to your description, your data consists of two tables. If you want slicer to filter another slicer, you need to set the filtering direction of these two tables to both

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.