Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

Problem with Bidirectional Relationships

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 ...

Need Help

v-cherch-msft
7 years ago
Hi Anonymous

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

Anonymous

Not applicable

7 years ago

Hi Ashish,

Here's the link:

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

v-cherch-msft

Microsoft Employee

7 years ago

Hi Anonymous

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

Regards,

Cherie

Sample (3).pbix187 KB

Anonymous
Not applicable
7 years ago
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
  Microsoft Employee
  7 years ago
  Hi Anonymous
  
  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

Forum Discussion

Problem with Bidirectional Relationships

Related content

Bidirectional relationship cardinality issue

bidirectional relationships

USERELATIONSHIP problems with n:m-relationship

Alternative to bidirectional relationship

One to Many Relationship Problem