Drillthrough page for transaction details or "See Records"
[Will Thompson] I'm merging a few suggestions to cover a scenario we've heard feedback on.
'See Records' lets you see the underlying rows in your tables that aggregate into the datapoint that you click on. Vote for this idea if you'd like to be able to customize a page that lets you drill into these detail rows. For example, you could create a page that has many visuals showing details about a particular set of 'facts' e.g. sales, events, bank transactions etc. You'd then be able to click on a datapoint and navigate to that view, filtered to just the facts that make up the datapoint you clicked on.
Like the new Drill options like See Records in Desktop. It would be nice to have the option to change the text color in the table to something other than black, or perhaps inherit the Data Label color from the main visual. It's difficult to see records for reports with dark backgrounds.`
Sarah Faber commented
Many of my users expect the same functionality as they get when they double-click on an Excel Pivot Table report to see the associated records, and the entire record in that table. Not to mention, they expect to do so on every visual, especially Cards.
This is very important for our users - any update on when this will be made available?
The drillthrough today works only with "implicit measures", i.e. using the value columns from the data model instead of real measures. It should be possible to use this new drillthrough also in combination with measures.
Raghuvardhan Reddy commented
It could be very useful if you Enable the hyperlink in bar charts .
For Eg: suppose , having Summery and detail data . Summery showing in one page and detail showing in another page . If user click on any bar that should navigate to details page .finally bars should work like as hyperlink .
John Fitzpatrick commented
This is really needed as anyone with a dark background on a report. The reports look a lot better when you customize the background colors, but for both "See Records" and "See Data", dark backgrounds make these functions practically useless.
Since the "See Data" function is basically the Matrix visual, it should have the same themeing capability as the Matrix visual does. And the See Records is basically the "Table visual" so it should have the same Format settings as a standard table.
As it is now, I make dark pages for the viewing of the data and metrics and if someone wants to drill into the data, I make light backgrounds of the same data to allow my users to see data / see records. Please fix soon. I also submitted this issue over a year ago and was hoping it would have been fixed by now.
I think its *really* poor that this isn't already implemented - or it's a bug. We have power BI reports with dark backgrounds to avoid eye fatigue, so the See Data and See Records functionality is effectively useless as you can't see the grey font color against the dark background.
This forces all Power BI devs to use white backgrounds ordinarily resulting in very samey looking reports.
Microsoft Provides drill through facility in SSRS. It would be very helpful to see the detailed information via passing the parameter from the Main Report.
Power BI Team, any updates on this?
Provide the ability to define the columns that should be displayed when using the show data feature. I would add a capability to the field well that allowed the visual creator to define the level of detail displayed in the detailed data view.