Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Relationship issue with 3 tables

Hi i Have three tables in my powerbi report and want to form a relationship between them but it wont let me.    Table_OEMFCST --> OEM Name to have a relationship with Table_OEMList --> OEM Name  T...
General Comment
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Dengliang, 

 

thank you for your response, i dont want to delete or make anything inactive as i need these relationships, is there a way of getting around it?

as currently the Table_OEMList and Table_OEMFCST helps me with linking my forcast data to a OEM name. 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi @JemB123,

     

    You can create a new table in Power Query as a reference to Table_OEMList.
    Any changes in the data source will also be synchronized to this new table.

    This new table can also be used as a slicer to filter the data in Table_OEMFCST.

     

     


    You can also refer to the following link for more information.
    How to manage ambiguous relationship in Power BI – Cloud BI


    Best Regards,

    Dengliang Li

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.