Skip to main content

Power BI

Completed

Drill to a report page

Vote (1425) Share
Nanda Kishore Reddy's profile image

Nanda Kishore Reddy on 03 May 2016 21:34:51

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.

Administrator on 09 Sep 2017 05:00:41

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!

Comments (86)
Nanda Kishore Reddy's profile image Profile Picture

prasanth on 05 Jul 2020 23:09:02

RE: Drill to a report page

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

Nanda Kishore Reddy's profile image Profile Picture

prasanth on 05 Jul 2020 23:09:02

RE: Drill to a report page

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

Nanda Kishore Reddy's profile image Profile Picture

Joel Faltermeier on 05 Jul 2020 23:04:59

RE: Drill to a report page

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

Nanda Kishore Reddy's profile image Profile Picture

Alaric Schenck on 05 Jul 2020 23:03:14

RE: Drill to a report page

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.

Nanda Kishore Reddy's profile image Profile Picture

Calvin H on 05 Jul 2020 23:01:53

RE: Drill to a report page

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.

Nanda Kishore Reddy's profile image Profile Picture

Ryan R on 05 Jul 2020 22:59:13

RE: Drill to a report page

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

Nanda Kishore Reddy's profile image Profile Picture

Niek Verhoef on 05 Jul 2020 22:59:01

RE: Drill to a report page

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!

Nanda Kishore Reddy's profile image Profile Picture

Niek Verhoef on 05 Jul 2020 22:59:01

RE: Drill to a report page

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!

Nanda Kishore Reddy's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 22:58:51

RE: Drill to a report page

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

Nanda Kishore Reddy's profile image Profile Picture

vp-comercial on 05 Jul 2020 22:58:48

RE: Drill to a report page

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.