Forum Discussion

ritika_ritika's avatar
ritika_ritika
Regular Visitor
11 months ago
Solved

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 ...
Need Help
  • MasonMA's avatar
    MasonMA
    11 months ago

    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)

     

     

  • v-hashadapu's avatar
    v-hashadapu
    10 months ago

    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..

  • v-ssriganesh's avatar
    v-ssriganesh
    10 months ago

     

    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.

grazitti_sapna's avatar
grazitti_sapna
Icon for Super User rankSuper User
11 months ago

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!