Skip to main content

    Power BI

    Completed

    Support for Hierarchies

    Vote (438) Share
    NiklasV's profile image

    NiklasV on 21 Aug 2015 15:09:27

    I have found no support for using existing data model hierarchies in either Power BI or Power BI Desktop. It is not either possible to create own hierarchies in Power BI Desktop. This feature would greatly approve the the ability to build reports based on eg. dates, geography and organizational structures.

    Administrator on 29 Mar 2016 06:23:23

    We've added this to the product. In the next release you'll also be able to drag and drop to create hierarchies as well.

    Comments (25)
    NiklasV's profile image Profile Picture

    e189f419 3b3c-4764-824c-7eabd09dedd4 on 05 Jul 2020 22:14:22

    RE: Support for Hierarchies

    This is a must for my company. I'm pitching Power BI as an alternative to Tableau, so my end users are very used to this feature!

    NiklasV's profile image Profile Picture

    dfd5263a 806d-4dcc-a6f0-643e90aa0d5f on 05 Jul 2020 22:13:51

    RE: Support for Hierarchies

    MUST... PowerView has this, SSAS Browser has this, SSAS Browser > Explore in Excel has this, crazy that PowerBI Desktop and PowerBI don't have this.

    NiklasV's profile image Profile Picture

    9523443c 7707-452e-9862-7d8f73fbcc39 on 05 Jul 2020 22:13:20

    RE: Support for Hierarchies

    Hierarchy is a MUST, basically end users love to drill up and down the DIM's, it's the main facility tool for end users

    NiklasV's profile image Profile Picture

    ad029e17 27bf-4edf-92a9-7df0c090ed04 on 05 Jul 2020 22:11:02

    RE: Support for Hierarchies

    I think it would be awesome if Power BI could be connected with Active Directory to allow for views dependent on role and department.

    NiklasV's profile image Profile Picture

    388ad109 0db2-4933-aa42-40b8102d60b9 on 05 Jul 2020 22:10:19

    RE: Support for Hierarchies

    Hi Andres, I don't think this is what people are asking for. If I have hierarchies defined in my Cube, I'd like to be able to see them in the Fields list and use the hierarchy as a whole in the reports.

    NiklasV's profile image Profile Picture

    a578c970 380f-4db5-942d-6e2132ea65f6 on 05 Jul 2020 22:09:33

    RE: Support for Hierarchies

    This is now possible with the update a couple months ago. Add more fields to the chart and it enables drill down with your defined hierarchy. I think the UI is still a little funky but the functionality is there.

    NiklasV's profile image Profile Picture

    e3f6051b 72e0-4e76-b989-248d75c492a9 on 05 Jul 2020 22:09:11

    RE: Support for Hierarchies

    Unbelievable that something as fundamental to reporting and analysis as hierarchies aren't supported out of the box

    NiklasV's profile image Profile Picture

    bb12ea0a 0ddd-4596-a6f3-166e1bbb7ccb on 05 Jul 2020 22:09:00

    RE: Support for Hierarchies

    Can't believe this is so low down in the pecking order. Support for existing hierarchies are such a key component.

    NiklasV's profile image Profile Picture

    0ec4507c a44f-407d-b8a4-b95660a04739 on 05 Jul 2020 22:08:38

    RE: Support for Hierarchies

    Hopefully this will soon be implemented in the upcoming updates of Power BI. The real-time connection to SSAS tabular and the ability to import Power Pivot data models loose much of their value if they cant be used as intended. Especially problematic when using explicit hierarchies.

    NiklasV's profile image Profile Picture

    7d723aae 5cdc-4d29-9b4c-06dbd6d3cbbe on 05 Jul 2020 22:08:12

    RE: Support for Hierarchies

    Does anyone know if this feature is on the roadmap as we may discount the entire product if this functionality is not available.