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 bridge table column in table visual too.

Table visual is okay when columns are used from one table connecting with bridge table but when columns from other tables connected to bridge table are added in visual, the visual encounters error and when checking there is message that there is no relationship between the tables.

I have also used bidirectional filters between tables but its not working.

Need Help

1 Reply

  • 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