Problem creating relationship

[javieezy]

Dear all, 

I was trying to create relationship of the MONTH between different tables so I can put data from different tables into the same visual. I wasn't able to create relationship. Am I missing something fundamental? 

Table 1

table 2

I also created date table, but neither

any help will be appreciated. 

Br, 

[v-luwang-msft]

Hi @javieezy ，

Try following soultion:

went to "Edit Queries" and selected the table where the non-duplicated values resided (the 'one' side of the relationship). I right clicked on the column containing the key values and selected "remove errors". Doing this then allowed me to create the 'many to one' relationship.

similar questions refer:

https://community.powerbi.com/t5/Desktop/The-cardinality-you-selected-isn-t-valid-for-this-relations... 

https://forum.enterprisedna.co/t/power-bi-relationship/1227 

https://community.powerbi.com/t5/Desktop/One-to-one-the-cardinality-you-selected-isn-t-valid-for-thi... 

https://community.powerbi.com/t5/Desktop/relationship-management/td-p/1297831 

Wish it is helpful for you!

Best Regards

Lucien

[sevenhills]

I will recommend to create a Month table, as you are interested in joining on Month.

Month Table columns

Month ... January, Feb... Dec...

MonthNumber ... 1, 2, 3, 4... 12

Mark Month column as Sort by column using MonthNumber, which will give better presenation of data in charts ...

hope this helps!

Check this article, to get an idea https://www.sqlshack.com/how-to-sort-months-chronologically-in-power-bi/

And then do the relationships to this Month Table...