Interactions between tables for multiple bookmarks

Hi Anonymous 

On your bookmarks unselect the data option as underlined in below screenshot. this should serve your purpose.

Hi, Anonymous 

I'm sorry.This is impossible. The bookmark saves the status of the reportpage at a certain point in time. It won't change the display effect of other bookmarks as you highlight a certain line of a bookmark.

You can reference:Use bookmarks in Power BI Desktop to share insights and build stories - Power BI | Microsoft Docs

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi akash1412,

This is not possible using bookmarks, as bookmarks stores the static visuals and are not dynamic but you can achieve is using alternative approaches.

You can create two separate pages for both the tables, follow below steps,

• Add a slicer for Common ID on Bookmark 1 page.

• Go to View → Sync Slicers.

• Sync this slicer to Bookmark 2 page.

• Hide the slicer on the second page (optional).

Approach 2 - You can add drill through to view details on another page, 

• Add Common ID to Drillthrough fields on Page 2.

• Right-click row 3 in Table A → Drillthrough → Page 2.

• Page 2 automatically filters to only the tasks for Common ID = 3.

Approach 3

Create a disconnected table: DAX = CommonSelection = DISTINCT('TableA'[Common ID])

create a filter slicer use below DAX:-

FilterID =
IF( SELECTEDVALUE(CommonSelection[Common ID]) = SELECTEDVALUE(TableB[Common ID])
, 1
, 0)

Apply this filter to Filter Table A & Table B where FilterID = 1.

add it to the filter pane.

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!

Hey @Anonymous akash1412 ,

Bookmarks in Power BI do not carry filter or selection context across pages. A bookmark only remembers the state of the page where it was created which visuals were shown, hidden, their positions, and optionally the filters/slicers on that page. But row selections inside a visual (like clicking a row in a table) are not preserved when navigating to another bookmark or page.

This is why:

• You click Common ID = 3 in Bookmark 1

• Then switch to Bookmark 2

• Bookmark 2 loads in its saved state and does not inherit the row selection from Bookmark 1

So even though your tables are related by Common ID, bookmark navigation breaks the interaction.

You can try the following alternative option by using a slicer instead of clicking rows:

Add Common ID as a slicer on all bookmark views (can be hidden if needed). Then, when you change the slicer selection:

• Table A (Bookmark 1) filters

• Table B (Bookmark 2) filters

• Put the slicer on all pages/bookmarks

• Use View → Sync Slicers

• Choose:

  • Sync = On

  • Visible = Off (where you don't want it to appear)

1) Table A filtered by using a slicer.

2) Table B also filtered by using the Table A current state.

I attached the pbix file you can check it out.

Best Regards,
Nasif Azam