Forum Discussion
Table row selection cause filtering to break within the same source
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.
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)
Hi ritika_ritika , Thank you for reaching out to the Microsoft Community Forum.
We find the answer shared by MasonMA is appropriate. Can you please confirm if the solution worked for you. It will help others with similar issues find the answer easily.
Thank you MasonMA for your valuable response..Hello ritika_ritika,
Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.
Thank you for being part of the Microsoft Fabric Community.
6 Replies
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)
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.
Hi ritika_ritika ,
- 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. - In Model view, check the relationship between the tables.
- Edit the relationship.
- Double-click the relationship line.
(Or right-click → Properties). - In the Edit Relationship window, look for:
Cross filter direction → change it from Single to Both (bi-directional)
OR
- If source is same,then use slicers instead of table clicks.
- Create slicers for your key fields (e.g., Trip ID, Customer, Date).
- 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!
- This is a bi-directional cross-filtering in Power BI. By default, when two visuals are set to filter each other,
Hello ritika_ritika,
Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.
Thank you for being part of the Microsoft Fabric Community.
Hi ritika_ritika , hope you are doing great. May we know if your issue is solved or if you are still experiencing difficulties. Please share the details as it will help the community, especially others with similar issues.
Hi ritika_ritika , Thank you for reaching out to the Microsoft Community Forum.
We find the answer shared by MasonMA is appropriate. Can you please confirm if the solution worked for you. It will help others with similar issues find the answer easily.
Thank you MasonMA for your valuable response..
