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)
RE: Drill to a report page
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.
RE: Drill to a report page
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?
Thanks Shez
RE: Drill to a report page
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.
RE: Drill to a report page
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.
RE: Drill to a report page
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....
Thanks
JB
RE: Drill to a report page
Do you have ETA on this?
RE: Drill to a report page
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.
Thanks!
RE: Drill to a report page
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.
RE: Drill to a report page
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.
RE: Drill to a report page
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.