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

    Malcolm 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

    Martijn 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

    Jerome 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

    Travis Kale 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

    Frederic Power BI User on 05 Jul 2020 22:20:34

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

    Excellent!

    Riccardo Muti's profile image Profile Picture

    Jerome 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

    Satya Vaitla 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

    Keith 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

    Power BI User 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

    Mike Ashton 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.