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.

[v-pgoloju]

Hi @Renukam,

Could you please share some screenshots showing where you're encountering the issue, along with the steps you're following in Power BI Desktop to achieve your requirement? This will help us assist you more effectively.

Regards,

Prasanna Kumar

[v-pgoloju]

Hi @Renukam,

As we haven’t received any further updates and there are no outstanding queries at the moment, we’ll go ahead and close this thread for now. If you have any additional questions in the future, please don’t hesitate to start a new thread we’re always here to help.

Warm regards,
Prasanna Kumar

[Renukam]

Hello, I've tried all the soulutions mentioned in the reply but those are not working.
Thanks

[v-pgoloju]

Hi @Renukam,

We wanted to kindly check in to see if everything is working as expected after trying the suggested solution. If there’s anything else we can assist with, please don’t hesitate to ask.

Warm regards,

Prasanna Kumar

[v-pgoloju]

Hi @Renukam ,

Just checking in to see if the explanation around bookmark behavior and selection context helped clarify the issue with overlapping visuals. If you have any further questions or need additional support, feel free to reach out we’re happy to help.

Best regards,
Prasanna Kumar

[v-pgoloju]

Hi @Renukam,

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

You're right when the "Data" option is turned on in a Bookmark, it saves things like filters, slicer choices, and row selections. So when you click a button to switch visuals using that bookmark, it resets everything, including any rows you selected earlier.

Kind regards,
Prasanna Kumar

[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,