Forum Discussion
sacheu
Microsoft Employee
Microsoft EmployeeHow to have 2 active relationships between 2 tables
I have 2 tables, each of them has its visual in PowerBI. And there is currently 1 active relationship between them. My question is how can I add a 2nd active relationship between them? so that w...
parry2k
Super User
Super Usersacheu you cannot have more than one active relationship, you have to use userelationship function to use inactive relationship.
sacheuMicrosoft Employee
Microsoft EmployeeSo if i have 1 active relationship and 1 inactive relationship. Each relationship maps to a different column of the tables.
How can i make the other visual update when i select 1 visual? I thought i need to have active relationship before i can get clicking 1 visual will update another visual working.