Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Interactions between tables for multiple bookmarks

Hey,   I have a 4 different datasets being pulled in with 1 common field relating to each other. I've created a bookmark view for each of the 4 different datasets that contains a table detailing th...
Need Help
grazitti_sapna's avatar
grazitti_sapna
Super User
8 months ago

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!