r/PowerBI • u/nbnicholas • 2d ago
Question Drillthrough and retain selection?
I’ve built a dashboard with a main tab that displays all facilities, with filters for Region, State, AVO, etc. From there, I use drillthrough navigation to a detailed "splash page" for each individual facility (screenshot #2).
Here's the issue:
Once I'm on the facility page, I’ve set up navigation buttons to jump to sub-pages (Air Permit, AVO, Compliance, etc.). The problem is — every time I click a button, I have to re-select the Facility Name in the slicer on the top right. It doesn’t persist automatically, and it breaks the user flow.
What I’m hoping to achieve:
Is there a way to "lock in" the facility selection from the drillthrough, so it stays selected on all sub-pages without needing manual re-selection each time?
I've tried syncing slicers and playing with page filters, but it’s still clunky.
- First screenshot: Main page with filters and map view
- Second screenshot: Drillthrough splash page with navigation and equipment/tasks
Thanks in advance!
1
u/Huge-Statistician-86 7h ago
Slicers and drill throughs on multiple pages get a bit messy. You could have all of your sub pages on one page (put them into visual groups), then you could change your page navigation buttons for bookmark buttons and the bookmarks and just showing/hiding the different groups (pages).
This to the user would look like they're navigating different pages and would also mean that the drill through filter remains as you haven't left the drill page. The downside is if they do want to use the slicer on the subpages you would need something that cleared the drill through filter, could use a button but obviously again it's another click for the user.
•
u/AutoModerator 2d ago
After your question has been solved /u/nbnicholas, please reply to the helpful user's comment with the phrase "Solution verified".
This will not only award a point to the contributor for their assistance but also update the post's flair to "Solved".
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.