Cross filtering from one table to another, but not vise versa

[y5famfnatudu]

Dear All,

In a pbi report, I have 2 tables, when I select a record from one table, the second table shows the related records. But when I select a record from the second table, then nothing is shown in the first table

How to make sure reords are shown as well when I select a record from the second table?
The sample report is attached.
Sample 
Your help is so much appreciated.

Best regards,

Simon

[v-mdharahman]

Hi @y5famfnatudu,

Thanks for reaching out to the Microsoft fabric community forum.

Just following up to your previous conversation with @lbendlin, I'd like to confirm if you've successfully resolved this issue or if you need further help.

I would also take a moment to thank @lbendlin, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.
Community Support Team

If this post helps then please mark it as a solution, so that other members find it more quickly.

Thank you.

[v-mdharahman]

Hi @y5famfnatudu,

As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.

If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.

If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.

[y5famfnatudu]

Thank you so much, but the issue is still open

[v-mdharahman]

Hi @y5famfnatudu,

Can you please confirm if you were able to work on the solution provided by @lbendlin and made some progress or the issue is still with the original question.

[y5famfnatudu]

Unfortunatelly, that didn't help

[v-mdharahman · Accepted solution]

Hi @y5famfnatudu,

Thanks for reaching out to the Microsoft fabric community forum.

What you're experiencing is due to the way visual interactions are configured in your Power BI report. By default, selecting a row in one visual can affect others, but only if the interaction is enabled for both directions.

In your case, it looks like the left table "Direct Revenue" is set to filter the right table "Through Partner Revenue", which is why that part works. However, when you click on the right table, the left one doesn’t respond most likely because the interaction from right to left is turned off.

To fix this click on the Through Partner Revenue table then go to the Format tab in the Power BI ribbon and choose Edit interactions. There you’ll now see filter icons on other visuals. Make sure the Direct Revenue table has the filter icon (funnel) selected, not the “no interaction” icon (circle with a line through it).

Once this is set, both tables should respond to each other's selections.

I would also take a moment to thank @lbendlin, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.
Community Support Team

If this post helps then please mark it as a solution, so that other members find it more quickly.

Thank you.

[lbendlin]

You are describing behavior that is more at home with QlikSense.  in Power BI you need to contort your data model into a *:* bidi relationship nightmare.