Table row selection cause filtering to break within the same source

[ritika_ritika]

Hi,

I have two table visuals in my dashboard, Trip Data and Detailed Report. Each table filters the other table. 
The issue is as follows: 
When I click on record from the Trip Data then Detailed Report is filtered - So far good. 
When I click on filtered data from detailed report, then Trip Data reverts to the full list and goes back to the original state! 

What I want is that on clicking filtered record on Detailed Report, the filtered data on Trip Data table should remain in filtered state.

[grazitti_sapna]

Hi @ritika_ritika ,

1. This is a bi-directional cross-filtering in Power BI. By default, when two visuals are set to filter each other,
   selecting something in one resets the other.
2. In Model view, check the relationship between the tables.
3. Edit the relationship.
4. Double-click the relationship line.
   (Or right-click → Properties).
5. In the Edit Relationship window, look for:
   Cross filter direction → change it from Single to Both (bi-directional)

OR

1. If source is same,then use slicers instead of table clicks.
2. Create slicers for your key fields (e.g., Trip ID, Customer, Date).
3. Apply slicers to both Trip Data and Detailed Report.
   This way, the filter context is consistent, and clicking on tables won’t reset each other.

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.

💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.

🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.

🔗 Curious to explore more? [Discover here].

Let’s keep building smarter solutions together!

[Elena_Kalina]

Hi @ritika_ritika 

That is indeed the normal behavior of interactions between visuals in Power BI. When you select a row in the second table, it "overwrites" the previous filter from the first table.

I usually create slicers with values from the tables that you would like to use for filtering the tables.

[MasonMA]

If i understand your question correct, you would want to stop bi-directional filtering between visuals and keep only one-way filtering?

If this is what you were looking, you would need to first select the Trip Data visual, go to 'Edit interraction'. 

On the Detailed Report visual, keep filtering enabled, then select the Detailed Report visual and on the Trip Data visual, turn filtering off/ set to “None”. (look for the buttons on top right of your visual as in this picture)