Forum Discussion
Bidirectional cross-filtering for different tables on same page
We have two different tables which are linked together as parent and child via a one-to-many relationship. We have two visual tables each containing fields from the parent and the child respectively, and we want to enable cross-filtering b/w the two.
Right now, filtering is working in the parent-to-child direction, i.e., clicking a on a row in the parent table results in filtering on the child table side as well (this is as desired), but not the other way around. Ideally, we want a user to be able to click a row in the child table and have both the child and parent tables be filtered in the visualization, but right now, the row in the child table is only being highlighted rather than filtered. If the ideal behavior is not possible, i.e., we cannot enable filter-on-click in the child table, then we would like to freeze the child table so that it is impossible to click on any row there.
Our users are getting confused about the relationship b/w the two tables b/c the filtering isn't bidirectional, so we cannot accept filtering on the parent table and highlighting only on the child table; either filter-on-click needs to be possible on both sides or the child table needs to be locked/frozen so a user cannot click on any given row. Is it possible to achieve this objective?
1 Reply
- lbendlinSuper User
That sounds more like QlikSense. They specialize on associative models. In Power BI bidirectional relationships are only used in special scenarios.
Worst case you will need separate data models for different business scenarios.