Unable to switch between table to matrix visual by retaining the selection

[Renukam]

Hi, I have 2 visuals overlapped on each other, one is table and another is matrix, I have provided 2 buttons to switch between 2 visuals. However If I select any row in matrix visual then the selection is getting persisted in table visual but if I select any row from Table visual the selection is not getting retained in matrix visual.
Please assist.

[Renukam]

Hi, thanks for the reply, If I keep the data option checked, then it doesnt keep the selection after we click on any of the buttons. It resets the data and selection as well.

[v-pgoloju]

Hi @Renukam,

Thank you for reaching out to the Microsoft Fabric Forum Community. And also thanks to @DataNinja777  for prompt and helpful respnose.

To ensure consistent interaction between the visuals, use a slicer based on a common field (like customer or category) to control both the Table and Matrix visuals instead of relying on row selection. Alternatively, make sure both visuals use the same key field in their row context, or create a measure using SELECTEDVALUE() to track the selected value and apply it across both visuals.

Best regards,
Prasanna Kumar

[Renukam]

Hi thanks for the reply, Client does not want to use slicers for the selection, client is making only row selection. That's the real bottleneck.

[v-pgoloju]

Hi @Renukam,

Thank you for reaching out to the Microsoft Fabric Forum Community.

At this time, I’m unable to find an alternative solution, as Power BI does not synchronize row selections across visuals each visual maintains its own selection context. Selecting a row in a Table visual does not trigger cross filtering on other visuals in the same way a Matrix can. This is a known limitation, especially when using overlapping visuals with bookmarks to toggle visibility.

Kind regards,
Prasanna Kumar

[DataNinja777]

Hi @Renukam ,

The issue you're encountering with selection persistence between your table and matrix visuals likely stems from how your bookmarks are configured. To resolve this, you need to ensure that the bookmark associated with your table visual is set to capture the data selection state. Begin by making a selection in your table visual. Then, navigate to the "View" tab and open the "Bookmarks" pane. Find the specific bookmark that activates the view with your table, click on the ellipsis (...) next to it, and ensure the "Data" option is checked. After confirming this, click "Update" to save the change to the bookmark. It's also best practice to verify that the "Data" option is similarly enabled for the bookmark corresponding to your matrix visual to ensure the selection is retained in both directions. By enabling the "Data" property for these bookmarks, you are instructing Power BI to save the current data context, which includes any active filters, slicers, or row selections, thereby allowing the selection to be seamlessly retained as you switch between the two visuals.

Best regards,