Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
hariamoor
New Member

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 1
lbendlin
Super User
Super 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.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.