Challenging Navigation Request - Buttons - Slicers - two actions one button

[tj7933]

Hello,

I have been requested to create a Power Bi report with a custom Navigation setup.  Here are the required details:

• The user wants a primary screen to select the department before the TOC (table of Contents).  On the primary screen, they would click on an appropriate button and be taken to the associated department Table of Contents (TOC)
• When they click the navigation buttons within the TOC, it will take them to the appropriate page/tab already filtered to the department selected from the landing screen.

  Make sense?

  I have been watching videos of Power Bi buttons for a few days.  It looks like I may need to create separate bookmarks for each department selected.  I am hoping I am missing something, so I keep searching for an easier way.

  Right now, there are 6 departments, with additional departments to be added over time.  
  
  There are nine pages/tabs, so I would need at least 54 different bookmarks if there is no way to link a button to both a filter requirement AND a bookmark.
  
  I am open to any suggestions. Please include learning materials where possible.
  
  Thanks for your help

  Tammy

[miTutorials]

Have you explored the Drill through function yet ?

This 'Drill Through' Feature in PowerBI will take your report to Next level | MI Tutorials - YouTube

[tj7933]

No, I will try that tomorrow.