How can we improve Power BI?

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.`

143 votes
Sign in
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

David E shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →


Sign in
Sign in with: facebook google
Signed in as (Sign out)
  • Biggy Mwithi commented  ·   ·  Flag as inappropriate

    The 'dataSelected' event seems to be returning ***values*** now but only for an instance at a time. I have a need to audit the records that the "See Records" even displays. This action triggers the "Page Changed" event with the page name "Drill To Details". Clicking on s single row of returned data triggers a 'dataSelected' event and the object properties are accessible. What I need is an ability to access the JSON object returned by the "See Records" action - "Drill to Details" page change event as an entire set. I observe the JSON returned by an XHR request and have not been able to access it. This is the important and final piece that would allow full auditing of records access etc. Ideally, an event to handle "Export Data" would similarly be useful.

    Proposed request: Under 'Report Events'
    Add a "Drill to Details" event that returns even dataset details as response values
    Add a "Export Data" event that returns event dataset details as response values


    Called when a report is fully rendered. For example, if all visuals are rendered on loading report or after user interaction.

    newPage: Page

    filtersApplied (Not supported yet)

    report: Report
    page: Page
    visual: Visual (Will be defined)
    filters: IFilter[]
    dataPoints: (Array of data points)
    each point has:
    1) **identity** array
    2) **values** array (In Progress)

    Raised when end user clicks on extension command.
    [Menu Commands Extension](

  • Sarah Faber commented  ·   ·  Flag as inappropriate

    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.

  • Anonymous commented  ·   ·  Flag as inappropriate

    This is very important for our users - any update on when this will be made available?

  • roloc03 commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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.

  • Russ commented  ·   ·  Flag as inappropriate

    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.

  • Pradeep commented  ·   ·  Flag as inappropriate

    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?

  • Anonymous commented  ·   ·  Flag as inappropriate

    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.

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.