Problem with Bidirectional Relationships

[Linda200]

I have loaded two excel (fact) tables into Power BI. Both have the same date formatting. However, when I create relationships between these two tables and my date (dimension table), Power BI imposes a bidirectional relationship on one of the tables, and a single, one-to-many on the other. I want both relationhips to be one-to-many. When I try to edit the bidirectional relationship, power BI says it is a many-to-many relationship. I have reviewed both excel tables and the date fields are formated exactly the same way, with no errors. What am I doing wrong??

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[Linda200]

Hi Ashish,

Here's the link:

https://www.dropbox.com/s/r3y2pepwxunxb4w/Sample.pbix?dl=0

[v-cherch-msft]

Hi @Linda200

You may check the attached file. Please let me know if it matches your request.

Regards,

Cherie

[Linda200]

Hello Cherie,

Yes, the file is fixed. However, can you please tell me what was wrong, and how you remedied it?

Thanks.

[v-cherch-msft · Accepted solution]

Hi @Linda200

You may change the Cardinality to 'One to many' first. Then change the cross filter direction to single. Here are some articles for your reference.

Create and manage relationships in Power BI Desktop

What is the Direction of Relationship in Power BI?

Regards,
Cherie