Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
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?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |