Brett Nodello on 19 Sep 2017 00:26:55
The current drill through capability does not appear to consider an active filter/slicer value for a visual unless the dimension being filtered is included in the parent visual. I think it would be helpful if it did.
For example; a table of customers subject to a slicer for specific stores should pass on both the customer and store values if these dimensions are both listed as drill through filters.
Administrator on 09 May 2018 05:25:11
As of the May 2018 release of Power BI Desktop you can now define your drillthrough to 'Keep all filters' which will apply the selections from slicers and other visuals to the target page as well. https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2018-feature-summary/#measureDrillthrough
- Comments (52)
RE: Drill through that considers slicer/filter context of a parent visual
Is this a duplicate with https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31363117-include-report-filters-in-drillthrough-action ?
RE: Drill through that considers slicer/filter context of a parent visual
Whole-heartedly agree that this is critical. Any drillthrough filter field defined in the detail-level page should be populated with the values selected on the page of the parent visual. I'm happy to provide a pbix file as an example if needed.