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

1db3c230 0fa3-4e29-873b-f512a8702a23 on 05 Jul 2020 22:58:34

RE: Drill to a report page

http://radacad.com/power-bi-drill-through

Nanda Kishore Reddy's profile image Profile Picture

df52c520 2c10-44e7-811d-365d4b7785f7 on 05 Jul 2020 22:56:49

RE: Drill to a report page

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

Nanda Kishore Reddy's profile image Profile Picture

81e90872 de82-43a3-ada8-1e10cb96353c on 05 Jul 2020 22:56:15

RE: Drill to a report page

Will, when are you releasing this drillthrough feature of a page?

Nanda Kishore Reddy's profile image Profile Picture

0c4c42d6 8add-4488-8b1b-bcc52355ba54 on 05 Jul 2020 22:55:58

RE: Drill to a report page

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 ?

Nanda Kishore Reddy's profile image Profile Picture

08d9ada6 5f85-43ed-95fc-ff39d92d5bfa on 05 Jul 2020 22:54:37

RE: Drill to a report page

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.

Nanda Kishore Reddy's profile image Profile Picture

ef1e5145 eb2c-45a1-a93c-f159333ce367 on 05 Jul 2020 22:51:18

RE: Drill to a report page

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.

Nanda Kishore Reddy's profile image Profile Picture

c6888ffc 4ab6-4fc8-a4e7-a9dea5be9203 on 05 Jul 2020 22:50:59

RE: Drill to a report page

Any ETA for that? I'm struggling to explain to my customers that "drill through" is not possible in Power BI.

Nanda Kishore Reddy's profile image Profile Picture

f8450234 bc6f-4f87-b58d-ecc9209153b5 on 05 Jul 2020 22:50:44

RE: Drill to a report page

If has been ~5 months - we should have an update on this by now.

Nanda Kishore Reddy's profile image Profile Picture

bbc29756 24ff-4ebc-92e1-2b7b9fb50395 on 05 Jul 2020 22:50:36

RE: Drill to a report page

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.

Nanda Kishore Reddy's profile image Profile Picture

276e69a9 8e0d-4460-a6ad-3a62d71a649e on 05 Jul 2020 22:50:10

RE: Drill to a report page

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