Forum Discussion

GKG's avatar
GKG
New Member
3 years ago

Need help regarding bridge table

I have a bridge table for 3 different tables but I cannot add the required columns in table visual from those 3 tables. When I add columns from different tables in visual, the error occurs. Have used...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi GKG ,

 

Even if both filters are turned on, there is a possibility of ambiguous relationships. Similar to the situation in this thread.

Solved: Bridge table: Can't display the visual

1. Consider modeling it this way (Brige table[1-*]Table1[*-*]Table2[*-*]Table3)

2. You may consider using the last or first value of each column in Tables 2 and 3.(Not recommended, may not meet the needs)

Back to the beginning, why not use only the columns from the bridge table? It should provide the correct filtering.

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum