Table visual changes unexpectedly when I click on a row on itself?

[Zhinee]

I have three table visuals on a report page:

• Session Status 
• Joblet Status 
• Joblet Detail Log

There are data model relationships:

1. site to session (many to many)

2. session to joblet (1 to many)

3. joblet to joblet_detail (1 to many)

Desired behavior: When I click on a row in Session Status, the Joblet Status table should show only the related rows (based on session ID).

When I click on a row in Joblet Status, only the Joblet Detail Log should change — Joblet Status itself should remain unchanged. 

Problem:

When I click on a row on Session table, then I click on a row in the Joblet Status table, it unexpectedly filters itself and displays a different set of rows.

For example, in the image below, I click on 14093824 in the Session Status row, and the table below will display all items with the ID 14093824.
After that, if I click on any row in the Joblet Status table, it unexpectedly changes to show different rows with different session IDs.

[v-veshwara-msft · Accepted solution]

Hi @Zhinee ,
Thanks for posting in Microsoft Fabric Community.

This behavior is expected in Power BI.

When you click on a field (or cell) in a table visual, it acts as a filter:

• It filters other visuals on the page based on model relationships.

• It also affects the visual you clicked on.

In most cases, the table visual will filter itself to show only the selected row.
However, if you click on a specific field (cell) instead of the entire row, Power BI may highlight the selected value (with a gray background) while keeping the other rows visible.

In your scenario, when you click on a row in the Session Status table, it filters all other visuals that are related to it.
Then, when you click on a row in the Joblet Status table, the filtering context now starts from there - meaning Joblet Status becomes the active filter and applies its filtering to other connected visuals, such as Joblet Detail Log.

Regarding Edit Interactions - this only controls how one visual affects other visuals.
You won't see a "None" (⦸) icon appear over the visual you're currently interacting from. So it's not possible to stop a visual from responding to its own clicks using Edit Interactions.

Hope this helps. Please reach out for further assistance.
If this post helps, then please consider to give a kudos and Accept as the solution to help the other members find it more quickly.

Thank you.

[Zhinee]

Thanks,
That explains the behavior I am seeing.
Now I am using a CTRL+Click to do multiple selection on different visuals.

[Shravan133]

• Click on the visual that causes the interaction — e.g., Joblet Status

• Go to the Format ribbon > Edit Interactions

• You'll now see icons appear on all other visuals:

  • A filter icon: this visual will be filtered by the selected one

  • A highlight icon: the visual will be partially highlighted

  • A circle with a slash: this visual will not be affected

• On the Joblet Status visual, disable its self-interaction by clicking the "none" (⦸) icon on itself.

• Similarly:

  • Let Session Status filter Joblet Status

  • Let Joblet Status filter Joblet Detail Log

  • Prevent Joblet Status from filtering itself

[Zhinee]

Regarding to : 

On the Joblet Status visual, disable its self-interaction by clicking the "none" (⦸) icon on itself.

I am not seeing a "None" icon for itself, I do see it on other visuals.