Forum Discussion
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 ...
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
Hello Cherie,
Yes, the file is fixed. However, can you please tell me what was wrong, and how you remedied it?
Thanks.
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