Forum Discussion
1:1 Relationship Cross-filtering Visuals
obera For the relationship between Table 1 and Table 2 you can override the default behavior (which is happening becuase it sees they are both unique) and set it to "1 to Many" (Table 2 as the 1 side, and Table 1 as the many side), and then set it so Table 2 filters Table 1 in a single direction.
Microsoft Employeeobera For the relationship between Table 1 and Table 2 you can override the default behavior (which is happening becuase it sees they are both unique) and set it to "1 to Many" (Table 2 as the 1 side, and Table 1 as the many side), and then set it so Table 2 filters Table 1 in a single direction.
Thank you! I don't know why this didn't occur to me. I'm pretty sure this solved it for me - I'm still having date issues, but the more I look at it the more I think that is something separate. Filtering is now working as I need it to.