cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
DavidS524 Regular Visitor
Regular Visitor

Drillthrough Confusion

Hello everyone,

 

I am trying to solve a problem I'm having with drillthroughs and slicers. I've been searching for a solution but none have worked so far. Basically I have the following setup:

 

Page A - Allows user to drillthrough on client name to Page B

 

Page B - Contains slicer on client name in case user wants to switch their selection.

 

Scenario 1 - User starts on Page A and drills through to Page B. They hit the back button when they are finished and return to Page A. They repeat this several times and all is well.

 

Scenario 2 - User starts on Page A and drills through to Page B. While navigating Page B they clear the selection and manually change the slicer to a new selection on client name "ABC". Then they hit back and return to Page A. When they try to drillthrough back to Page B for client "XYZ", they now see blank visuals. This is because the slicer is still set to "ABC" and the drillthrough filter is "XYZ".

 

I understand that they can use a button to clear the selection before returning to Page A. However this means that the user must remember to use it before going back to Page A and performing another drillthrough. This is something that will likely be forgotten.

 

What am I missing here? This must be an extremely common scenario that people encounter. I created a sample pbix file but do not see any good way to attach it here. Please let me know if you need any more information.

 

Thank you!

4 REPLIES 4
Community Support Team
Community Support Team

Re: Drillthrough Confusion

Hi @DavidS524 ,

 

Please update your pbix to One Drive and share the link here.

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
DavidS524 Regular Visitor
Regular Visitor

Re: Drillthrough Confusion

My organization has outside file sharing turned off on One Drive. I have tried uploading the file to Drive. Please let me know if the link does not work or if you have any further questions. Alternatively if you direct message me with your email I can send you a link from One Drive.

 

https://drive.google.com/file/d/0B0nHetNbmoC3U2hIZE42SWRwVHpJdTlNQnEzd2k0UWluTXp3/view?usp=drivesdk ...

DavidS524 Regular Visitor
Regular Visitor

Re: Drillthrough Confusion

@v-frfei-msft

 

Hi, Frank. Were you able to access the file above? Thanks!

dotcs_farrellv Frequent Visitor
Frequent Visitor

Re: Drillthrough Confusion

I think this is a duplicate of https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31755214-drillthrough-and-slicer-... Please go there and vote for it to increase the chances they'll fix this. (I agree with those that think this is more of a bug than a feature request - either way I want it fixed)

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 426 members 3,982 guests
Please welcome our newest community members: