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
'@ Tobias Owen, the February update addresses it with Sync Slicers for slicer filters, but not visual filters or filters applied from the Filters Pane such as visual filters or page level filters.
Slicer Sync helps, but does not address the real need which is "I am filtering data on a page with a combination of slicers, visual filters, and filters pane, and want to be able to drillthrough to a filtered dataset of what I am seeing after those filters are applied"
This is what Drillthrough SHOULD be in my opinion. "Complete ability to drillthrough WITH ANY/ALL FILTER CONTEXT. Ability to customize what filter types (eg slicers, visual filters, Page Level, Visual Level, and/or what specific field context is passed through."
RE: Drill through that considers slicer/filter context of a parent visual
February 2018 update may address this with the ability to sync slicers with drill-through tabs.
RE: Drill through that considers slicer/filter context of a parent visual
Please add this functionality, it's very important for Drill Trough functionality.
RE: Drill through that considers slicer/filter context of a parent visual
Drill through without persisting context leads to erroneous results (context set by a user in report/page filters and/or slicers).
RE: Drill through that considers slicer/filter context of a parent visual
In our migration efforts to PBI, this is a big deal. As others have reported, detail data in the drill though page does not produce expected results.
RE: Drill through that considers slicer/filter context of a parent visual
I won't be able to use drilldown at all for most of my report pages, since the results are too confusing for users. So, basically, I'm not able to use drilldown at all until this is fixed.
RE: Drill through that considers slicer/filter context of a parent visual
I support
RE: Drill through that considers slicer/filter context of a parent visual
Consider this as a page extender. A new drill through page type that is an extension of the original page. All active filter/slicers would come active (or not) as if the visual object was created on the first page. The pages are designed with this in mind. Some way to edit interactions between these pages would have to be developed.
RE: Drill through that considers slicer/filter context of a parent visual
MUST HAVE PLEASE POWER BI DEVELOPMENT TEAM
RE: Drill through that considers slicer/filter context of a parent visual
Must Have!