How can we improve Power BI?

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.

255 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Brett N shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    18 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Piotr commented  ·   ·  Flag as inappropriate

        +1
        If someone is using the date ranges and is trying to drill through on e.g. customers category to see a volume of sales - it is a necessary feature.

      • Tin Dang commented  ·   ·  Flag as inappropriate

        This is super important & urgent in term of analytical story designed in Power BI and should be basic feature of any analytics tool. Please prioritize this first than any other features.

      • Matthew Lingard commented  ·   ·  Flag as inappropriate

        I was hoping that the December release would have fixed this major flaw. we desperately need a fix for the Drillthrough feature. We need the full context of the report including all filters and slicers to be passed to the target report.
        BTW, I believe this feature should be called Drillacross not Drill through, but anyway.

      • Matthew Lingard commented  ·   ·  Flag as inappropriate

        It would be great if we can get an update from the PowerBI team on this request. I agree with ALL the comments below especially cbaillis that this feature is basically half built and could create major issues with end users. Please prioritize this as super urgent.

      • Antonio Chan commented  ·   ·  Flag as inappropriate

        Hi relatively new to PBI.

        Ditto to all the aforementioned points particularly about having working slicer and filters elements not part of the parent report. In my case, a matrix report that also allow users to select different row/column level of details.

        One addition feature request is to consider having a working drill through target page report with data supported by one set of table/models that are different from the parent page report source tables, as long as the "drill through filters" or fields listed on the target page can be explicitly "matched" or defined a filter relationship from the parent to the target page report.

        For example, the parent page report is a high-level summarized (by account) P&L with data come from a financial ledger table, while the target drill through page report reflects detailed information (like account, cost center, detail description, other statistical fields and etc) from a journal line table. In a typical ERS, financial data from the journal line table are posted and aggregated to the ledger table at the account level. In defining the drill through filters for the target page, one should be able to explicitly define the account field listed in the ledger table is matched with the account field listed in the journal line, cost center from ledger is matched with cost center from journal line and etc. This way, drill through to another page can effectively provide a new way of viewing different type of related detail information from tables other than those tables supporting the parent page report.

      • cbailiss commented  ·   ·  Flag as inappropriate

        The current implementation of drillthrough is very incomplete i.e. IMHO basically broken/not usable. It should not have been released in it's current state because it makes it very easy for users to be misled / see the wrong data.

        Slicer selections from the summary page don't seem to be carried through to the 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. Or worse still the user does not realise the slicer selections are missing and so gets a completely different/wrong/misleading set of values.

      • PowerAnalytics commented  ·   ·  Flag as inappropriate

        A must have feature.

        Power BI users after having filters applied before applying drill through do not understand that the previous filters are now unselected.

        Bottom line we need to make end user experience a positive one, so this is absolutely required, otherwise the feature itself is useless.

      • Joel Faltermeier commented  ·   ·  Flag as inappropriate

        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.

      • Jon Leins commented  ·   ·  Flag as inappropriate

        Please add the ability to "pass through" multiple filters via a drill through. Otherwise, it's borderline useless!!!

      • Anonymous commented  ·   ·  Flag as inappropriate

        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

      • Kelly Dittmar commented  ·   ·  Flag as inappropriate

        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.

      • David Hernandez commented  ·   ·  Flag as inappropriate

        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.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Without this functionality their are very few cases where I would want to use this new drillthrough feature. Report consumers will be very unclear about the data the drillthrough page is displaying if it does not pass through the existing filters.

      Feedback and Knowledge Base

      Ready to get started?

      Try new features of Power BI today by signing up and learn more about our powerful suite of apps.