Forum Discussion
Helper IIbi-directional cross filter
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 New_worker ,
Agree with shafiz_p .
Your initial thought about only one active relationship is understandable, but in Power BI, you can have multiple active relationships between tables, especially when dealing with complex models. The key is to ensure that the cross filter direction is set correctly to "Both" to enable bi-directional filtering.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
New_workerThank you Anonymous for the reply. I can see the corss filter direction for the many-to-many relationship is set as both, the double arrow. so that means the first step to enable the bi-directional filter is to define the relathionship as active?
Hi New_worker ,
Yes, if you want to enable the bi-direction filter, you need to make the relationship active first.
For more information, please refer to
Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.