Skip to main content

Power BI

Needs Votes

Drillthrough and slicer conflict resolution

Vote (180) Share
Peter Ivers's profile image

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 (21)
Peter Ivers's profile image Profile Picture

Power BI User on 05 Jul 2020 23:01:34

RE: Drillthrough and slicer conflict resolution

I actually think this is a bug. Why would you want to drill through without applying the filters/selectors that are relevant to the item you are drilling from. It appears that only the native PBI filters are applied