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

7a03b206 6c02-4b58-b7e9-b4ae7ccf0cbe on 05 Jul 2020 22:08:09

RE: Support for Hierarchies

Our tabular cubes leverage hierarchies to simplify dimensions and ease of use. Not having this features requires us to maintain two tabular cube solutions or have many more unneeded fields in our dimensions

NiklasV's profile image Profile Picture

18e0bbd5 fd58-4632-92e5-a2e3b620b2fa on 05 Jul 2020 22:08:06

RE: Support for Hierarchies

Have the same Problem here. I found a possibility to build a kind of hierarchy in the Bar Chart with the last update, but in Matrix view there is nothing and we definitely need Hierarchies or drill possibilities there!

NiklasV's profile image Profile Picture

cc7b6879 80d1-4247-8890-b404e2df2d8a on 05 Jul 2020 22:08:03

RE: Support for Hierarchies

I agree, being able to use hierarchies that already exist in an SSAS tabular model (or to create these in PowerBI) and use them as drill throughs would be very useful.

NiklasV's profile image Profile Picture

117e9a71 15fd-4d53-96b5-a44d199976f3 on 05 Jul 2020 22:08:01

RE: Support for Hierarchies

I agree, this is a significant shortcoming currently. Essentially makes existing hierarchies worthless, and necessitates manually building drill downs where they are supported.

NiklasV's profile image Profile Picture

04f986d2 f371-40a5-815b-f2c04162d18b on 05 Jul 2020 22:07:36

RE: Support for Hierarchies

Specifically hierarchies in SSAS Tabular as these are usually already in place if the Company has a SSAS Tabular model already.