Peter Ivers on 04 Oct 2017 19:50:58
Make a drillthrough look for any slicers on the page with the same field and set them to the drillthough value.
Lets say your target is a page all about a widget with a widget slicer. An end user might slice widget A on that page. Later the user goes to another products page and sees widget B in the list, and drills through to the Widget B page. It will come up blank as the drillthrough filter is B, but the page is sliced to A, and there is no widget that is both A and B.
This is caused because the drillthrough filter and slicer are ANDed and the slicer may be set to a previous value by an end user, so zero rows are returned.
- Comments (15)
RE: Drillthrough and slicer conflict resolution
We are also waiting for this issue to fix, which will help us in performance
RE: Drillthrough and slicer conflict resolution
this would really help, the idea of creating a second page is ok, but not good. can you please fix it?
RE: Drillthrough and slicer conflict resolution
This would be really useful - it does seem like a bug at the moment. Please fix!
RE: Drillthrough and slicer conflict resolution
For those struggling with this we have a workaround that is by no means a solutions - and a potential maintenance headaches (as it involves multiple copies of the same things)
But what we did was create two pages - one that would only be used via drilled through, and one that has a splitter on that field but no drill through. The drill through one is hidden so as to not confuse the users too much. It's not great from a maintenance point of view but vastly improved the user experience.
Trying to have splitter and drill through on same field just doesn't work I Power BI. To the point where they really should throw up an error when you try (or FIX IT !!!)
RE: Drillthrough and slicer conflict resolution
This feature would help my work immensely.
RE: Drillthrough and slicer conflict resolution
This feature would not only ease my work, but also add great value to the product. Looking forward to a fix.
RE: Drillthrough and slicer conflict resolution
We intend to use drillthrough feature to enahce the user experience of our reports. Rather than having a user re-set the slicers each time they want to navigate to a new report (time which these reports are supposed to be saving the user......), this drillthrough feature will allow SEAMLESS switching between reports with the same filters.
Currently our users are VERY CONFUSED at the functionality provided in the half-baked drillthrough in the current version of Power BI.
RE: Drillthrough and slicer conflict resolution
Faced the same issue when I was working with Power BI...
RE: Drillthrough and slicer conflict resolution
drillthrough feature is half-baked without this linkage - M$, how did you intend for drillthrough pages to function autonomously if you don't give end users a slicer to choose the value driving the drillthough page? Did you just assume that people would always return to previously pages and then drill back in to the drillthrough page? Having communication between the drillthrough element and page slicers on the drillthrough page seems like a pretty easy to identify critical use case for making this functionality work in the real world. I love Power BI, but honestly I wonder what your UX people are thinking half the time.
RE: Drillthrough and slicer conflict resolution
Really need this feature.
For example, we have 2 pages - overview and details by product. Second page contains slicer "Product". If a user drills from overview page to detailed, he or she will not be able to select another product on this page using the slicer. So now we disabled drilldown feature. Hope you'll provide some solution!