Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
144 | |
72 | |
63 | |
52 | |
49 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
57 |