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)
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