Forum Discussion

AZJohnPowerBI's avatar
3 years ago

Filters

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.

1 Reply

  • aj1973's avatar
    aj1973
    Community Champion

    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