Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Creating relationship without unique values

  Hello All,    I have been try to create a relationship between two columns in power BI but I am getting the message "You cant create a relationship between these two columsn because one of the c...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi Anonymous

     

    Power BI supports, 1:1, 1:M, M:1 relationships only, not M :M. But there is a work around for this.

     

    Option 1. Create a relationship/ bridge table to handleM:M

    Option 2. Create a Unique column in your current tables ( For example: By concatenating 2 columns to make the values unique).

     

    Thanks

    Raj 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Anonymous

 

Power BI supports, 1:1, 1:M, M:1 relationships only, not M :M. But there is a work around for this.

 

Option 1. Create a relationship/ bridge table to handleM:M

Option 2. Create a Unique column in your current tables ( For example: By concatenating 2 columns to make the values unique).

 

Thanks

Raj 

  • derydebs's avatar
    derydebs
    New Member
    2 years ago

    I have the same problem but this time with dates. I have two different tables I want to show these records on a single line graph showing how they both performed on specific dates. Obviously this means some dates will have multiple records. So it will not be unique. How do i go around this?