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

125 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    7 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • 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.