Skip to main content

Power BI

Completed

Drill to details (view row-level data)

Vote (953) Share
Riccardo Muti's profile image

Riccardo Muti on 13 Nov 2014 10:05:12

Whenever I see an aggregated metric (e.g., $483,572 in sales) - in, say, a column in a chart or a cell in a matrix - I should be able not only to drill down to a next level of detail, but to "drill to details" - all the way down to the individual rows of data (e.g., the individual sales orders) that make up that value.

Administrator on 29 Apr 2016 05:02:48

Thanks for all the feedback. We just released the April version of Power BI desktop, including new drill functionality. You can drill into a particular column in a chart and see the records behind that part of the visual. For more info on this feature and other features in our latest release, check out this blog post: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-april-update-feature-summary/

Comments (62)
Riccardo Muti's profile image Profile Picture

Eric Hutton on 05 Jul 2020 21:57:11

RE: Drill to details (view row-level data)

This would also need to come with the ability to restrict the user from doing such drill downs, in cases where there might be data security/privacy restrictions.

Riccardo Muti's profile image Profile Picture

Rui Quintino on 05 Jul 2020 21:56:59

RE: Drill to details (view row-level data)

kind of related would be very useful to be able to click any cell value and open a new temporary report page filtered for that specific context allowing for a drill down analysis . this one time drill page could then be dropped or saved in the report, without changing any existing page