"Your cant create a relationship

[jhaldane]

Hi team, 

Objective:

I would like to have a graph / table showing:

- cardboard collected & cardboard verified

When i try and create a relationship, i receive an error. Please see below.

- The "Value" in Card collected  table and "tonnage" in Card verified are unique.

Thanks in advance.

[MFelix · Accepted solution]

Hi @jhaldane,

PBI by default make 1 to many relationships and this is the error given when you are trying to make a many to many relationship you can select the cardinality to have the many to many.

However as a good practice and to simplify the model the best way is to create a date table with unique values and relate that table with your two tables.

Regards,
MFelix