Forum Discussion

Zhinee's avatar
Zhinee
Icon for Helper III rankHelper III
1 year ago
Solved

Table 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 ...
  • v-veshwara-msft's avatar
    1 year ago

    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.