Forum Discussion
bi-directional cross filter
- 1 year ago
Hi New_worker Answer is C. You need to change cross filter direction to both to enable bi - directional filtering. Your confusion might stem from the image of the test(They wanted to confuse you). But remember, they want to know how to enable bi directional, not what would you do to enable bi directional when both one to many and many to many bi directional relationship exist.
Also, your thought is correct. In power bi, you can have only one active relationship, others will be inactive.
Hope this clearify your thought!!
If this, please accept it as a solution and a kudos!!
Best Regards,
Shahariar Hafiz
Hi shafiz_p ,
I think I understand your point. You see the cross filter direction is already set as both for existing the many-to-many relationship from the data model.
Also, I think the question is asking to enable bi - directional filtering and row-level security for the many-to-many relationship.
Imagine why they would test your knowledge by suggesting you delete the many-to-one relationship to enable bi-directional filtering. In real life, would it be necessary to "delete the many-to-one relationship" to make a many-to-many relationship bi-directional as well as "define the relationship as active"?
Those options are for you to get confused and still you are.