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.
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:
Drill to a transaction details page:
Thanks for your support and votes!
Stuart Charles commented
The requirement from my point of view at least is fairly simple. When a user clicks on a dashboard widget and gets taken to the underlying report, I would like the filters in the dashboard widget automatically passed through to my report.
I have a dashboard widget showing revenue filtered for my particular Department, when I click through to the underlying report, I would like that filter for my department retained. That may be at the visual, page or report level, however I set the filter up when I pinned the dashboard widget.
Rory Neary commented
Hi I see 2 key behaviours.
1. To enable drilldown into the underlying data that makes up the report with the relevant page filters applied. I am mindful that where measures have been used it is likely that this would be at an aggregate level.
2. Enabling navigation from one report to another, which is on a separate tab. I would expect that in this case any filters in the current report would be applied, where relevant.
Great news! I would like to see it function a bit like the 'see records' function, except instead of taking you directly to the records, you can define what level in the drill hierarchy it jumps you to a particular page. So this would function at a set level within a drill hierarchy, or if there is no drill hierarchy set, it acts as a hyperlink. Essentially, link a dimension to a page. Use cases might be drilling down through a date hierarchy until you get to day, then going to another page to show hours/minutes etc. as you may want to lay out a 'within the day' page differently to whole days/weeks etc.
We are doing some driver analysis which, once you drill down through regions, areas and depots to get to a particular driver, at that point we'd like to jump to another page showing lots of other things about that particular driver
A good example I see many times is from Finance where they have a couple of KPI's from the P&L. They often want to view the underlying level in this case a a more detailed transaction report. If filter contexts could be passed to the drill-through report this would make for a nice fluid experience.
Hadi Eissa commented
this is a must for a dashboard that has a large program or portfolio of projects. the main dashboard would include high level numbers and graphs on the health of program from schedule to cost to risks to issues. let say there is a tile on the main dashboard showing that there 5 projects that are behind schedule. the user needs to click on that and power bi will take him/her to another report showing a list of those 5 projects with details on those projects like status of the main phases (design, procurement, construction) and then also be able to click on construction to see the main WBS under construction and their status. SSRS and even excel vba can do that which makes very hard for us to introduce Power BI
Any updates on this? This is a very useful function in reports, and users found this would be more intuitive In viewing the reports.
Steve Brown commented
I would very much like to be able to drill down into a graph, and see the data behind it. My specific need would be something like this.
I have a column graph indicating the number of tickets raised by a customer. Drilling down into a column, which may represent a month for that customer would take me to a table showing the tickets that made up that column.
It would be really nice to have this feature.
That would be very useful for our reporting needs. Also, consider the possibility to create links inside a report - make it possible to add a button or image that links to another report page.
Kishore Surana commented
I would like to be able to provide a Url with all the filters specified within it. Clicking on the url should open up the report with all the filters selected (as specified in the url parameters)
Absolute requirement for my kind of reporting
Is Drill-through possible in Power BI? Not Drill-Down
Kristen Martel commented
needed before much of the functionality that has been started. this is basic navigation stuff.
another approach would be to enable vertical listing of the tabs in a report. The horizontal scrolling does just not work once you have more than 5 tabs, it really is a barrier to users exploring the reports we spend hours building.
It´s also very inconvenient to rearrange the order of the tabs when you have many + when you add a new tab it´s always inserted at the end. grrrrr
Mehul Parikh commented
Hi, I would like to create a hyperlink from a chart on page1 to another chart on page1 - based on which data/segment I select in the chart on page 1.
Basically to be able to navigate to new page rather than drill down to the data level when we click on the chart.
Based on the length this has been under review, I am giving up hope on having links to other Tabs or Reports within Power BI. This really is big problem that is stopping adoption of power BI
This is much needed we have built Power BI reports as the quick view but then need to easily drill into the data details behind the viz. The paginated reports are already built in SSRS, just need to be able to link the two together. This is a HUGE time saver and the first question we get when users know the detail is in an existing report, "can't we just click to get there?". Thanks! 1 million votes :)
I'm still missing a basic functionality which I used to have in many other BI tools and it's the option to explore the data/report/single data point by a drill through or drill across. This functionality creates a linkage between seperated reports that one has more detailed information and explain the other. It is NOT a drill down functionality which was there in power BI since day 1 and I don't want to use the tile kind of thing.
This feature would be very helpful in analyzing data and get the details based on that.
+3, please get this done!
I think this functionality is also listed with a heap of votes elsewhere on this site. Please include, would be a great step forward and increase usage of the tool