Filtered by the other child with mutual parent

[stephenli]

I have this relationship and I want to have the visual with Frontline Data to be filtered by the choice of the Team Hierarchy filtering visual. Is it possible since they have a mutual parent? Current it is not working at all.

[v-xicai · Accepted solution]

Hi @stephenli ,

You may change the Cross filter direction of the relationships among the three tables above from Single to Both, which will take these tables treated as a single table. So when you filter one table' field in visuals, the other tables' fields in visuals will return corresponding result.

You can learn more about relationship :https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships.

Best Regards,

Amy

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

[stephenli]

Thanks for your answer, but i have a very similar problem where the relationship shown as below:

I would like to show the branches on Map where the tooltip shows "Branch" instead of "ID". However I put "Branch" into the Location section but it doesn't load properly.

Relationship Keys:

(TeamLatLong) ID <-> dept_id (all departments)

(all departments) dept_code <-> Team Code (Team Hierarchy)

Do you have any ideas?

[d_gosbell]

That layout of relationships indicates that you have a many-to-many relationship between the Team and Frontline data. If you read through this whitepaper https://www.sqlbi.com/whitepapers/many2many/ it will explain how to build calculations that will work with these types of relationships.