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

Power BI User on 05 Jul 2020 22:08:23

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

This is a very important feature and most of the reporting tools have this feature. I am afraid this might lead us not using Power BI :(

Riccardo Muti's profile image Profile Picture

Rob Duke on 05 Jul 2020 22:06:20

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

I'd like to be able to change the visualization, sort order and value rows as I move down through the drill down too.

Riccardo Muti's profile image Profile Picture

SK HO on 05 Jul 2020 22:03:38

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

Tableau allows user to drill the detail and download the detail in a few file formats. This is extremely useful for business user.

Riccardo Muti's profile image Profile Picture

Firdous Shamsudeen on 05 Jul 2020 22:02:10

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

Please add Drill through (link) capabilities in Power View Report

Riccardo Muti's profile image Profile Picture

Miguel Bento on 05 Jul 2020 22:02:03

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

This is absolutely critical to our business users, and a feature that has been seriously lacking. You will make a LOT of people happy by plugging this hole! :)

Riccardo Muti's profile image Profile Picture

Saravanan on 05 Jul 2020 22:01:55

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

Is Drill Through Action available to see the underlying data?

Riccardo Muti's profile image Profile Picture

Michael Hawker on 05 Jul 2020 22:01:16

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

Yeah, I click on a bar in my chart and it highlights and says X number which is great. But if I double-click I expect it to take me to a table to show me exactly which rows made up that data. This is a powerful feature in a lot of analytical tools, and it's missing here. It would really make for intelligent insights.

Riccardo Muti's profile image Profile Picture

Adam Smith on 05 Jul 2020 22:00:57

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

All users to select a segment of a Power BI visualizaition and view the underlying detailed information via right-click or other similar function.

Riccardo Muti's profile image Profile Picture

D Chan on 05 Jul 2020 21:58:54

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

Like Tableau, once you construct charts and diagrams to show the % or consolidated number, enable users to drill down the underlying records that make up the numbers on the chart

Riccardo Muti's profile image Profile Picture

Hong Zhang on 05 Jul 2020 21:58:36

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

Drillthrough (drill to details) is such a critical function that we have to change to other technology (e.g., Excel) only because the business users demand this function. They use it not only for information purposes but also as a way to validate the summary level data in the chart/table. Please add this function to PowerBI as soon as possible. Thanks!