Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
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.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
6 | |
6 | |
3 | |
2 | |
2 |
User | Count |
---|---|
6 | |
4 | |
4 | |
4 | |
3 |