Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now

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.
Status: Completed
Comments
cristhian_neuma
New Member
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.
chrisho
Advocate I
Any updates on this? This is a very useful function in reports, and users found this would be more intuitive In viewing the reports.
RoryNBi
Advocate I
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.
fbcideas_migusr
New Member
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.
stuart_charles
New Member
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. E.g. 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.
irsimeonov
New Member
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!
prijo08
New Member
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.
keith_bates
New Member
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.
lee_hawthorn3
New Member
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.
joel_clark1
New Member
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