Forum Discussion

EricC's avatar
EricC
Frequent Visitor
5 years ago

Relationships between 3 tables and visual filtering issues

Hi all - I have 3 tables: Table A, B and C.   Table A relationship to Table B is 1:1 on an employee ID Table B relationship to Table C is 1:1 on employee email   ISSUE: When I use data from tabl...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Are you seting your table relationships to bi-direction? If not, then you should set it for both relationships.

 

Relationships have direction, if you only set it to single direction, A to B. Then you can only filter table B by table A.

 

 

EricC's avatar
EricC
Frequent Visitor
5 years ago

Do you mean cross filter direction? If so, it's set to Both by default for each relationship.

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi EricC 

     

    You are right. With Table B acting as a "middleman" table, Table A should be able to filter Table C if the cross filter direction is correct and the relationship is active. Can you provide some sample data or sample file? Or you could refer to this article (Model relationships in Power BI Desktop) to learn more about relationships. In addition, which visuals do you use to filter?

     

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.