Advanced Slicer Selection Reset For Drillthrough Pages

Learn how to leverage a bit of bookmark magic to clear/reset slicer selections on a drillthrough page. Even when those slicers have no association with any of the drillthrough filters.

BECOME A CHANNEL MEMBER 🎉

LET'S CONNECT! 🧑🏽‍🤝‍🧑🏽 🌟

VIDEO CHAPTERS 🎥
0:00 - Start of Video
0:36 - Content Intro
1:40 - Creating the Bookmark

HAVENS CONSULTING PAGES 📄

EMAIL US AT 📧

#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax

[ralfw]

Exactly the solution I was looking for. Well explained in a short video. Great! Thanks.

[nissashraff]

I was struck with similar issue and this video helped🙏

[katharinecooney]

Thank you, Reid, I thought I was going to be stuck until I found your video

[gianlucadepasquale]

thanks for this video. A really not trivial application combining slicers with drill-through. Fantastic!

[oricchannel]

Nice trick, Reid. Saved my day. I was looking for something like this for a long time. Thank you for sharing.

[ashishmohan]

Hi Reid,

Amazing trick you are doing great
Exactly this the thing which i required for my project

Thanks Reid
AM

[redsubcero]

Nice! It was very helpful for me, just what I was looking for, thanks a lot

[VladMZ]

Good post. Funny thing, I just designed my own solution for the similar challenge a few weeks ago. In my case, I have to drill to the detail page that shows atomic transactions, but without the drill-through functionality (which is annoying to the users) but rather using a set of buttons on summary page. So I created a set of bookmarks on the detail page that correspond to the criteria on the home page, i.e. Closed vs Pending, etc. However, I also wanted to pass a filter for the selected period and another criteria, which I achieved with hidden synchronized slicers. This is where your implementation ends, but I wanted to go further. I wanted for users to be able to change the pseudo drill-through filter without leaving the detail page and continue their analysis. Let's say I drill through to see closed trx, which I pass via hidden slicer. I also have the Closed appear on the detail page as a slicer, but this is actually a button that looks exactly as slicer with the use of images and button text magic. Now when user wants to see Pending trx without leaving the detail page, they click "fake" slicer and it navigates them to the identical page where the button replaced with the real visible Trx Type slicer.
I can't stress enough that we have to jump through hoops and waste our time inventing something like this just because Microsoft won't give us conditional navigation by a calculatable name of a bookmark, just like they did with the page navigation.

[SM-dozt]

Hi, This idea is surprised.
Thank you.
I have one question.
What should I do if I can drill through from multiple pages?
Is there any other way other than creating multiple back buttons with bookmarks?
It would be greatly appreciated if you could explain the details.

[subu]

Is there a video where you had explained how you had designed both the table in both the page - which looks like pivoted table with sub total and total for each coloumn. I tried with all visual option, but was not able to have a table matrix that looks like the one you had shown here in the video - Mainly the one in the destination page.

[DvilsAdvcate]

So, I'm definitely not an expert, which is probably why I struggled to understand your solution, but wouldn't you be able to just select the visuals you want the back button to affect, and then go from there? My back button is also associated with a bookmark to "Reset Drill-Through", and it seems to work the same as your method, but there wasn't a need for the extra hidden slicer. I just made sure the visuals I wanted to reset were selected when I "Updated" the bookmark, and now when I click the back button, it resets the visuals I want it to and keeps the others the same. I'm sorry if this doesn't make sense or is completely unrelated, but I'm really just trying to understand the difference, if any.

[Akki-kfxq]

How did you get the back button to do two actions ? Navigation and bookmark 😳

[JokerJax]

hi, the video is good. but i found it difficult to understand on viewing it the first time. if you could explain a litter slower then it would be good. thanks!

[Daniel-itm]

In my case your solution didn't work copied it step by step, syncing slicers doesn't override the drill-through filter for me it basically just layers on the filters, not sure why yours works

[SergiyVakshul]

The problem you are solving is really a pain in the back. The workaround you used works, which is great, but in a real world scenario this workaround is inapplicable as it gets you back to a certain page where as the starting page for the drill through operation could be different.

[Baldur]

That's why I don't have slicers in my Drill Through pages (which always are hidden) for the user's playground I have details page which is not hidden