Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric certified for FREE! Don't miss your chance! Learn more

Drill through that considers slicer/filter context of a parent visual

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.
Status: Completed
Comments
nishalit
New Member
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
dn_hernandez
New Member
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.
warren_meads
New Member
I consider this to be a bug. Why would you want to drill from an element in a visualisation that itself has been subject to selectors and other user filtering actions say from drop down selectors and or other visualisations to a drill down page that does not represent the item you have just drilled from
KellyDittmar
Advocate IV
I was just coming here to log this idea. As an example: Assume I run a school. Assume I have a "Class Details" report with 2 drill thru filters: year & Teacher Assume I have a "School Details" with a date filter at the top and a list of teachers & counts of students. The current behavior is observed: 1) I select a year at the top of the "School Details" report 2) "School Details" filters to show only those teachers during that school year. 3) I right-click on a teacher's name and select DrillThru to the "Class Details" page 4) "Class Details" page loads with a filter only on teacher - but NOT on year. This then displays every student who has had this teacher regardless of year. What is desired: Any filters that have been applied on the source page that have "drill thru options" set up on the drill thru page should be passed to the drill thru page.
KellyDittmar
Advocate IV
Is this a duplicate with https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31363117-include-report-filters-in-drillthrough-action ?
jleins2
New Member
Please add the ability to "pass through" multiple filters via a drill through. Otherwise, it's borderline useless!!!
joel_faltermeie
New Member
Reposting this seems to be the same idea as: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31363117-include-report-filters-in-drillthrough-action
rdurairaj
New Member
I support
lmundia
Frequent Visitor
I support
joel_faltermeie
New Member
This functionality is really important for Drillthrough to be truly powerful/useful. To add to some points/ideas above and in comments: If a user has selected slicer filters, page level filters, or visual filters (eg. bar in a chart), the context being applied to show the "filtered data" should all pass through to the page being drilled into. One example would be any drillthrough filters on the target page should be applied/passed through.