The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
In this for the table "Availability planning" I have 3-4 relationships with "GradeMapping", "DIM Calender" , "Month Standard hours" and "Week Standard hours" with this I have actually come with a visual as well.
Now I am supposed to add another table to the same visual "WRBE" which has the same things as "Availability Planning" -
Like - "Grade" to map to "GradeMapping Table" and also Date to map to "DIM Calender"
the issue is, I can successfully map "WRBE" - realtionship "Date" with the "DIM Calender", but If I try Grade as well- it shows an ambiguous realtionship
I am aware it is because I am already having a relationship with the "Availability Planning" hence not able to make that relationship.
Is there any work around ?, as I have filters from the Availability planning applied on the visual which should change with WRBE as well
Solved! Go to Solution.
Hi @akashpadmakumar ,
Based on the description, have you added another table to the visualization that has a relationship to the WRBE table?
If the content of the other table is the WRBE table, it is able to map the grade to the Grade Mapping table.
What’s more, try to create the inactive relationship.
Besides, you can also view the following document to learn more information.
Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn
Solved: Relationship ambiguity - Microsoft Fabric Community
Solved: Ambiguity relationship - Microsoft Fabric Community
Solved: Power BI - ambiguous relationships - Microsoft Fabric Community
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @akashpadmakumar ,
Based on the description, have you added another table to the visualization that has a relationship to the WRBE table?
If the content of the other table is the WRBE table, it is able to map the grade to the Grade Mapping table.
What’s more, try to create the inactive relationship.
Besides, you can also view the following document to learn more information.
Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn
Solved: Relationship ambiguity - Microsoft Fabric Community
Solved: Ambiguity relationship - Microsoft Fabric Community
Solved: Power BI - ambiguous relationships - Microsoft Fabric Community
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
why are all these relationships set to 'both' direction?
no specific reason, if I make them all uni directional I can make this relationship work ?