Forum Discussion

captainlaw's avatar
captainlaw
Microsoft Employee
9 years ago

Desktop Edit Relationship - Cannot Select Multiple Columns

Hello Community, I'm trying to select multiple columns (Name & Team), but the Desktop tool only allows me to select one.  Is there limitation to the tool to allow multiple columns for the join?  See ...
Need Help
captainlaw's avatar
captainlaw
Microsoft Employee
9 years ago

That will be a limitation compared with Tableau and Qlik. 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi captainlaw,

There is a limitation in Power BI relationship that we can’t create relationship with two or more columns, some ideas about this issue have been submitted in the following links, please vote them.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15013392-multi-select-columns-in-relationship-view
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10321815-composite-key-support-in-power-bi

To work around this issue, you can create a new column in both tables using the following formula , then create a relationship based on these new fields.

Newcolumn = [Name] & [Team]

Thanks,
Lydia Zhang

  • captainlaw's avatar
    captainlaw
    Microsoft Employee
    9 years ago

    Thanks Lydia.  I've just voted to help prioritize.  Cheers.