Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply

Ambiguous relationship issue, please help.

akashpadmakumar_0-1729080912693.png

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

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

vjiewumsft_0-1729130134369.png

 

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.

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

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.

vjiewumsft_0-1729130134369.png

 

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.

HotChilli
Super User
Super User

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 ?

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors