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!
I have the scenario that I would like to apply a navigation pane on the report page itself, so the user can see where he is. Since everything so far is clickable, I would like to have the navigation pane clickable as well, so the user could jump back from the report page to the Dashboard etc. I am using images to visualize the navigation pane. The solution I need would be that I could attach a hyperlink on this image as I can do on the Dashboard.
Denton Chase commented
When you accumulate 10 or more tabs for example it would be helpful to have a HOME PAGE that allowed a user to navigate with HYPERLINKS to selected views, or tabs in Power BI Desktop (and PowerBI.com)
The tab views construct was a great invention 25 years ago BUT Pretty Cro-Magnon when it comes to a modern BI interface.
Is there an EAT on when this feature will be available?
Button/Image/Icon/Link to navigate to other report would be fine
TJ Doherty commented
Need to be able to navigate across pages in a report from a main menu page to pages within the report, and/or to other reports. This is pretty basic document hyperlinking which I can't understand why it has not yet been incorporated into the Desktop PowerBI. Note that we need it in the Desktop for clients who are restricted from having data "in the cloud".
It will be great if this option is extended to getting direct link to a certain page of the report while publishing it.
sandeep movva commented
Do you have any ETA on this still please?
Is there a timeframe for release of this functionality? -- ie first page of BI Report being an index that can drive to other report pages via a hyperlink?
Sam T. commented
I have two scenarios where this is very necessary - and currently not possible, as far as I can tell. 1) Parent-child tables, where navigating to a record in one visualization (parent table) would select the corresponding rows in another visualization containing the child table. 2) Some of our tables are so huge that they cannot be accommodated with the 1GB report size limit of Service or the 1 million row limit of direct query. For these, we are building tables containing totals. As the user analyzes the totals, it would be great if they could click on a row and link to a visualization based on the underlying details table. (We are beginning to experiment with Analysis Services to see how much of this we might accomplish there.)
Thanks, this functionality will be very helpful. I hope to see it in preview in the not-too-distant future.
Agree, Tableau allows me to easily create a custom link that will pass parameters for the selected viz and render an SSRS with the details. These are just point to existing SSRS reports.
Today, Tableau and Qlik provide the ability to select an item from a table or a chart on Report A and see details of the selected items in Report B. This way, the user only needs to select a value once on a 'Summary' page and see all related content on another page. This needs to be replicated in Power BI.
For example - select a bar showing all Open POs for 2017, that drills through to a Details page with custom visualizations on those POs only. Any additional filters applied at the Page level should continue to perform as-is.
This also required urgently because as PowerBI will replace other reporting tools in organisation, you need support the key reporting functionalities of tools such as Qlikview, SSRS. Opening a new report/map and drilling into other linked reports are crucial to Data Users. Can let us know when this feature is planned to be released?
Mike Ashton commented
Another scenario: Clicking on a map area pops open a small window showing the transactions pertaining to that region. This second window can itself be drilled through as necessary.
A seemless navigation experience will be a major benefit to PowerBI. It's great news that you're looking at this.
Adam M commented
I would like to also add how important this feature is. This would really be a crucial piece to start moving a core set of SSRS reports to the Power BI platform. Our users have no appetite for losing the drill down capability that is mentioned in this suggestion.
JB DISDET commented
If it means that we will be able to navigate through reports and report pages, or even from report to Dashboards, it is a MUST have...
Navigation is in my opinion the real weakness of Power BI versus it main competitor....
Jeff Yi commented
Do you have ETA on this?
Hi, I think an extension of the existing interaction functionality as described below would be great.
Currently, in a single report page, one can define how choosing/clicking on an element in a chart would affect the rest of the charts in the current report page i.e. filter, highlight or not impact them.
I would like to be able to also (1) define the same behaviour as above but for charts in pages other than the page the current chart is situated in. I think the default behaviour of the charts in other pages should be 'no impact i.e. no filtering or highlighting'; (2) when clicking on an element of a chart that filters/highlights charts situated in other pages, there should be a dropdown/tooltip showing where the user can choose to jump to any of the charts in the other pages (this is similar to how Tableau handles actions).
I think the above would also address the scenarios described by others.
Alex Kyllo commented
I want to be able to script an experience, where for example if the user clicks on a column in a column chart, the chart changes to a pie chart showing the breakdown of the values in that column, and then if they click on a slice of the pie chart, it takes them to a matrix showing a summary of the data in that slice of the pie--basically the ability to script a change of chart types when drilling down.
Scenario: Summary report showing high level details of transactions with a list of the transaction ID's or other attributes present. Ability to 'click' an ID, attribute, etc and drill to a detail report or tab on the same report and pass the filter conditions from the first report. This would allow complex details to be present on a 2nd report and users can start at summary and click through to the detail.
Jon Price commented
I work in a PMO for a large IT organisation. Our project manager-focussed Power BI dashboard currently shows a list of the project manager's projects on the first report (a table of their projects), with a second report showing the detail for a single project (eg. monthly financial figures). At the moment the project manager has to filter the second report down to a single project manually. It would be much more user friendly if they could select a project from the first report and it would filter the project in the second report (eg. by applying a filter to it), effectively drilling down from their portfolio view into a single project. Clicking on charts won't be an appropriate solution in this case - it needs to be table based.