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

    ce53001e e1b7-47eb-b779-ff6e44d2b92c on 05 Jul 2020 22:21:10

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

    Still cannot drill down in a Matrix .

    Riccardo Muti's profile image Profile Picture

    2227acda 8bc2-47ea-9b41-7c67a15d1d1c on 05 Jul 2020 22:20:55

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

    I agree with Travis. We would like to see support for SSAS tabular models.

    Riccardo Muti's profile image Profile Picture

    8202a5a6 3568-48d3-a2c2-49e3fd23ee09 on 05 Jul 2020 22:20:44

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

    I was hoping that this feature would work in Power BI online. Not just in Power BI desktop. Any plans to include it in Power BI online?

    Riccardo Muti's profile image Profile Picture

    cae85417 dac8-4a38-8b0e-d4cecb5be034 on 05 Jul 2020 22:20:38

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

    How can you mark this complete? It does not work for SSAS tabular/MD live connections. Feature is not done.

    Riccardo Muti's profile image Profile Picture

    f1a832d9 8a5f-4dda-81c5-e5229b36bd2c on 05 Jul 2020 22:20:34

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

    Excellent!

    Riccardo Muti's profile image Profile Picture

    8202a5a6 3568-48d3-a2c2-49e3fd23ee09 on 05 Jul 2020 22:20:32

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

    Can someone from Microsoft comment on an eta for this feature? I am testing Power BI for my organization and this question comes up all the time.

    Riccardo Muti's profile image Profile Picture

    e6a84dd7 026f-427a-80d8-474787ffbe34 on 05 Jul 2020 22:20:05

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

    one of the must. without this we can not know what rows contributed for this total and can not take decision. Tableau handles this in excellent way

    Riccardo Muti's profile image Profile Picture

    2dec24d9 8235-4545-996e-72a996602e34 on 05 Jul 2020 22:19:57

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

    This feature is extremely important for my company as well.

    Riccardo Muti's profile image Profile Picture

    867acb98 4982-4816-a048-da30d82dc6e9 on 05 Jul 2020 22:19:57

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

    We also waiting for this feature to migrate to PowerBI from Tableau. Since it's started, could you give ETA please.

    Riccardo Muti's profile image Profile Picture

    876b00d3 d66e-41c2-b657-e4a00b8f0f71 on 05 Jul 2020 22:19:49

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

    This will be very useful. It was the first thing our Actuaries asked for when I demonstrated PowerBI.