How can we improve Power BI?

Drill to a report page

Ability to select/click a row on the table or chart and be able to contextually go to another report , with appropriate filters. This is only useful when we are able to hide the pages in the report and they appear only when something is(row or cell) selected on a table or similar chart.

1,455 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Nanda Kishore Reddy shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    I’m pleased to say that the September release of Power BI Desktop includes the capability to drill between report pages. More details in the blog post here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-september-2017-feature-summary/

    There are a couple of related ideas that you can vote on if you’d find them useful:
    Drill into an SSRS report:
    https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/6740219-ssrs-reports-for-drill-down-into-detailed-reports
    Drill to a transaction details page:
    https://ideas.powerbi.com/forums/265200/suggestions/13662768

    Thanks for your support and votes!

    86 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • prasanth commented  ·   ·  Flag as inappropriate

        i mean that for example we have one pie chart have different names those different names drill through is many pages so that we have any possibility go that one visulalization into many pages it will help full for me

      • prasanth commented  ·   ·  Flag as inappropriate

        we have drill through option for one page to one based one column but i need is there any possibility to drill through one viuslization data into many pages by using power bi

      • Joel Faltermeier commented  ·   ·  Flag as inappropriate

        Agree with Niek, Alaric, and others that this is great, but many do not feel it is complete.

        1. Needs to be able to pass parameters, match SSRS functionality.
        2. Should at minimum be able to apply filters applied to the target drill page.
        3. Should pass all context that has been applied to filter data from slicers or visual filters.

        There are 2 ideas open that relate to #2 and #3 I listed above. Please Vote to get more attention:

        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/31472473-drill-through-that-considers-slicer-filter-context

      • Alaric commented  ·   ·  Flag as inappropriate

        I would not call this completed. Please let me know when the type of drill through functionality supported by SSRS has been implemented in Power BI, such as drill through from one report to another by passing parameters, drill through by clicking on a label, column heading, link, row, table cell, etc.

      • Calvin H commented  ·   ·  Flag as inappropriate

        Thanks for the Power BI Team's effort to bring this feature into the September release. But what is also expected is the ability to drill to another report, not only report page.

      • Ryan R commented  ·   ·  Flag as inappropriate

        I agree with Niek Verhoef. If all slicers from previous report's page were applied, it would make this even better.

      • Niek Verhoef commented  ·   ·  Flag as inappropriate

        Great update, would be even more perfect and usefull if the slicer selections from the report would also be applied to the drill trough report! Maybe create a setting to inherit slicer settings yes/no? With default setting yes (inherit).
        Keep up the good work!

      • Niek Verhoef commented  ·   ·  Flag as inappropriate

        Great update, would be even more perfect and usefull if the slicer selections from the report would also be applied to the drill trough report! Maybe create a setting to inherit slicer settings yes/no? With default setting yes (inherit).
        Keep up the good work!

      • Lawrence commented  ·   ·  Flag as inappropriate

        Thanks for the new update. As another person mentioned, it would be great if it could also include the slicer selections.

      • vp-comercial commented  ·   ·  Flag as inappropriate

        I've used this new capability but in a different way. I've created a first page as an index of my report and now I can move from the first page to the rest of the report. It Works in the power BI desktop but when I publish it, it doesn't recognize it. It would be great if you could programme the arrow and go wherever you want instead of the last page you've been in.

        Thanks for this reléase.

      • Anonymous commented  ·   ·  Flag as inappropriate

        This feature would be very helpful. Please provide a status on the release of this feature

      • Shaligram commented  ·   ·  Flag as inappropriate

        Any updates on this?

        we have project where need to Must implement drill through and its hold on due to this functionality. Any idea or suggest ?

      • md commented  ·   ·  Flag as inappropriate

        Echo Sanjay Shah, it's important to have not only drill through within same PBI desktop but also drill to another reports, which could be PBI Desktop/SSRS report or even just a hyperlink. SQL Mobile (aka DataZen) and in fact almost all enterprise reporting tools have such basic capability.

        I fully understand PBI starts for self service BI, it's critical now to catch up such enterprise BI required capability, otherwise, it's very difficult to deploy.

      • Sanjay Shah commented  ·   ·  Flag as inappropriate

        Hi Will. The drill through to the target page should not just be linked to a field. It should also be linked to a visual. For example on a page i may show a visual of Orders Booking, another of Invoicing and a third of Account Receivable. Now i should be able to click on the Account Receivable visual and drill down to the detailed Account Receivable page. Trust that this capability is also being given.

        Secondly while the drill down is good from page to page, the real power would come when you permit drill down from one report to another, support multiple models in a single PowerBI file and permit the creation of visuals from different model on one page connected by common parameters. Something similar was possible in Datazen. Trust that such capabilities are there on the road map and would come soon.

        Congrats and thanks to the whole PowerBI team to take up this extremely important functionality.

      • Anonymous commented  ·   ·  Flag as inappropriate

        I strongly request this much needed feature which is pretty much staple in Excel, Powerpoint, Word etc, ie the ability to hyperlink to a different page or location in the report.

      • Luc van de Plas commented  ·   ·  Flag as inappropriate

        There should be an option to drill down from items such as KPI's to charts for more detailed information per period.

      ← Previous 1 3 4 5

      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.