Skip to main content

Power BI

Needs Votes

Drillthrough Should Use Slicer Selections

Vote (7) Share
's profile image

on 27 Nov 2017 17:28:45

The drillthrough feature looks very incomplete (i.e. IMHO basically broken/not usable), unless I am missing something. Slicer selections from a summary page don't seem to be carried through to a details page. So you can either use slicers or drillthrough. But not both together in a report. Because if you use both together, the drill through doesn't show you what you intuitively expect to see.
Example:
Data Table (in the data model) has four columns:
- ID containing a sequential number (set to "Don't Summarize").
- A containing values a, b, c
- B containing values p, q, r
- C containing random numbers
The table contains 20 or so records so that every combination of a/b/c and p/q/r is present in the data.
I have a summary report page, that contains a slicer on column B plus a simple column chart with A on the x-axis and sum(C) on the y-axis.
I have a details report page that just contains a table with all four columns in the table, plus columns A and B in the Drillthrough filters on the page.
I make a selection in the slicer on the summary page (e.g. just to select B=q).
I then drill through in the chart, drilling through on the bar column for value A=a.
In the details page, the table is filtered to A=a, but the filter on B=q is missing. So I've drilled through to a different data set.

Comments (3)
's profile image Profile Picture

Veronica Farrelly on 05 Jul 2020 23:58:40

RE: Drillthrough Should Use Slicer Selections

This is a duplicate of https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31755214-drillthrough-and-slicer-conflict-resolution

Please go there and vote for it to increase the chances they'll fix this. (I agree with those that think this is more of a bug than a feature request - either way I want it fixed)

's profile image Profile Picture

Joel Faltermeier on 05 Jul 2020 23:11:58

RE: Drillthrough Should Use Slicer Selections

I think this is solved by the new Sync slicer feature that was just released Feb 2018. However, The issue of other filtered context (eg from visual filters) not being able to pass through is still a major lacking area. Please vote for the below idea to address this shortcoming!

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31363117-include-report-filters-in-drillthrough-action

's profile image Profile Picture

Joel Faltermeier on 05 Jul 2020 23:06:10

RE: Drillthrough Should Use Slicer Selections

Completely agree. There are some other ideas asking the same that have more votes. I'm personally surprised there is not more support from the community yet for these ideas, unless Drill Through is still so new that users are not realizing how it actually works (or doesn't work).

Please vote for these ideas to get more attention/traction!

There may be some help/resolution with slicers applying to multiple pages, even if they are "hidden" on other pages, which is an idea marked as started recently.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31363117-include-report-filters-in-drillthrough-action

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31755214-drillthrough-and-slicer-conflict-resolution

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31341964-use-drillthrough-filters-as-filters-in-report-canv