Forum Discussion
Setting proper slicer value when drilling down
Welcome to the single selection paradox !
The report is not "messed up".
It is just doing what you told it to do.
Not what you want it to do,
Computers can be so annoyong sometimes 😀😀😀
Single selection does what it says on the tin.
And it will remember the previous selection as the next default, which may screw your report.
The work arround is to add a table visual (not a slicer) on the master page.
With a drillthrough button to your child page.
Hide the child page and save and publish the report whilst on the master page.
This will force the users to only select one option before the drill through button is enabled.
When the user clicks the button they will navigate to the next page.
but will be unware of what is happend under the hood.
It sound like you also need single selection on the second page.
Dont add single selection slicer.
You can daisy chain several drillthrough master / child / grandchild pages
each with a drill though rather than using a single selection slicer.
As soon as use the single selection slicer you are screwed,
because single selection slicers do what they say on the tin.
Whereas drillthough steps through. Try it and practice !
Thanks for reaching out for help.
I put in a lot of effort to help you, now please quickly help me by giving kudos.
Remember we are unpaid volunteers and here to coach you with Power BI and DAX skills and techniques, not do the users job for them. So please click the thumbs up and accept as solution button.
If you give someone a fish then you only give them one meal, but if you teach them how to fish then they can feed themselves and teach others for a lifetime. I prefer to teach members on this forum techniques rather give full solutions and do their job. You can then adapt the technique for your solution, learn some DAX skills for next time and soon become a Power BI Super User like me.
One question per ticket please. If you need to extend your request then please raise a new ticket.
You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you !
This does not solve anything, as the target tab's behavior doesn't change. Hiding the target tab is not an option, because both scenarios needs to be available:
1) Drilling through to a category (target tab)
2) While on the target tab, selecting different category to view corresponding data
Also, there is no need to add a table on the "master page" because drill through, by definition, passes current filter context to the target page; this ensures that drill-through is available from literally any data point that has appropriate dimension as a context filter (if that dimension is configured as a possible filter on the target page).