Forum Discussion
Helper IIITable visual changes unexpectedly when I click on a row on itself?
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.
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.-
4 Replies
v-veshwara-msftCommunity Support
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.
ZhineeThanks,
That explains the behavior I am seeing.
Now I am using a CTRL+Click to do multiple selection on different visuals.
-
Shravan133Super User
-
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.
-