Filters

[AZJohnPowerBI]

I have sensitive data so I can't post images but I can describe the problem.

One of my graphs is a decomposition tree, which shows the relationship and filters with managers --> supervisors --> agents perfectly.

However, when I make a bar graph or any other graph, and place an agent slicer, it shows all potential people instead of agents that strictly under the right supervisor.

I hope that makes sense, any help would be greatly appreciated.

[aj1973]

Hi @AZJohnPowerBI 

Add a bidirectional relationship between the 2 tables in questions.

Or

in the filter pane of the slicer add the field for people you want the slicer to work on