Creating automatic filter for a visual tied to a filter from another visual

[BSheen]

Hoping for the power of community to find solution to this.

I am not acquianted very well with PowerBI, and I have a feeling that for what I have in mind, it's not exactly the best tool. I'm trying to understand how can I make a visualization with custom filtering, where I can show results of an internal company survey on the same report page, on the left side for a certain manager, and on the right side automatically for this manager's "peer group".

In my head it looks pretty simple: filter A which selects a manager and is applied to a visual A10 (stacked bar) + A11 (card: manager name), and another automatic filter B (?) which is applied to a second visual B10 (stacked bar), and consists of 2 conditions:

1. all managers of the same grade as manager from filter A
2. excluding the manager from filter A

I would also potentially need to calculate deltas between "manager view" and "peer view".

I can't seem to grasp whether it's even possible to create a "custom automatic filter" without any aggregations and tied to a filter from another visual. I have a feeling I'm approaching this the wrong way.

Here is my simplified data model:

And this is approximate visualisation which I'm aiming for (of course showing incorrectly the same data on the B10 chart as on A10):

Any ideas/ comments would be most greatly appreciated. My pbix can be found here.  

Thanks a lot in advance! 

[lbendlin]

In Power BI filters on a table are applied on top of each other ("AND").  What you want is an "OR" filter - you can only achieve that with a second copy of your Managers table.