Barny on 12 Sep 2017 22:39:34
As much as I like the new Drillthrough actions, it seems a bit lacking in that it does not also pass through any report filters that are active on the source report on the source report.
Administrator on 10 May 2018 00:17:24
As of the May release of Desktop this is now supported! All filters (report, page, visual, slicers and cross-highlighting) can be passed through to the detail page. https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2018-feature-summary/#measureDrillthrough Thanks for voting!
- Comments (8)
RE: Include report filters in Drillthrough action
i support
RE: Include report filters in Drillthrough action
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.
RE: Include report filters in Drillthrough action
Reposting this seems to be the same idea as:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31472473-drill-through-that-considers-slicer-filter-context ?
RE: Include report filters in Drillthrough action
YES
RE: Include report filters in Drillthrough action
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
RE: Include report filters in Drillthrough action
Is this a duplicate with this idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31472473-drill-through-that-considers-slicer-filter-context ?
RE: Include report filters in Drillthrough action
This is definitely helpful for instances where you could filter a range of dates, and where it would be impractical to add date column to the drillthrough table (since it would change the grain). Taking report/page filter (such as slicer) would allow not having to add the filter to the column.
RE: Include report filters in Drillthrough action
I can't use the drill through until this is added. I always have report filters, and they get ignored by the drill through....