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

cc4b3747 0140-4ae6-b46f-9b2f2bf073de 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

856365a7 b0f7-417e-9369-956ee535f320 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

f2f05ab4 eae7-4a0f-a768-ad4b8788a8fb 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

8f78d578 a5cf-4a34-8114-c2da165b6dc5 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

42f71a5b 52f3-4e6a-b93b-78de7bb7499a 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

49a49c04 9bba-42b9-a2f7-0f45f87f3729 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

77408316 0491-4085-9ac5-165b69170770 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

a28e74fd 695f-4460-84e5-1af858d7d0e2 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

770047b2 605d-418c-b40c-ac7c8f4cf747 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

ac6a775a ff6b-45df-9f23-745cf9be1fc2 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!