Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
EricC
Frequent Visitor

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 table A and table C, visuals do not affect each other (Selecting data on 1 visual does not filter another)

 

Can someone help me understand the relationships between tables? I would've thought that if the tables are related, with Table B acting as a "middleman" table, then when I use data from Table A and Table C I would not have issues with filtering visuals.

3 REPLIES 3
Anonymous
Not applicable

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.

 

 

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

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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.