Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Bridge Table Failure

I'm encountering a challenge while attempting to address a many-to-many relationship between two tables using a Bridge table in Power BI. Despite establishing one-to-many relationships from the Bridge table to the other two tables, I find myself unable to display columns from all three tables simultaneously. Instead, I can only choose columns from the Bridge table and one of the other two tables, leading to a recurring "can't build relationship" issue. My goal is to showcase columns from all three tables simultaneously. Any guidance on resolving this issue would be greatly appreciated. Need Help

  • Anonymous's avatar
    Anonymous
    2 years ago

    I have got the solution to the same, I was trying to get two unsummarized data in a table which is not possible. 

2 Replies

  • Musadev's avatar
    Musadev
    Resolver III

    Share the 2 tables and also the bridge table. Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable

    I have got the solution to the same, I was trying to get two unsummarized data in a table which is not possible.