Power BI

Completed

Support for Hierarchies

Vote (438)

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)

Comments (25)

303d7cb3 41cb-46dd-8698-e07a2b226662 on 05 Jul 2020 22:34:56

RE: Support for Hierarchies

I am doing live connect to Tabular Model and wanted to create hierarchy for one of my dimension (not date dimension). I don't see option when I right click on the field to add hierarchy. Please advise

b7ad3915 e66d-4da2-b9ce-9f348e2e11d4 on 05 Jul 2020 22:26:10

RE: Support for Hierarchies

I am not able to view the hierarchies from my tabular model in Power BI Desktop connected through live connection. Does anyone knows what might be the issue here?

689cde87 fdd4-4341-8a1b-1ed49df05acf on 05 Jul 2020 22:24:20

RE: Support for Hierarchies

I am able to create hierarchy. However, if I had created the hierarchy by mistake, how do I drag it out of the hierarchy again?

Thanks;

218f21f6 dc9c-4a7a-abc2-cab4121f8d58 on 05 Jul 2020 22:18:12

RE: Support for Hierarchies

If I drag a hierarchy with (fiscal) years and weeks to a graph, I can only display one of the two. Result is that the weeks are being sorted from low to high, messing up the hierarchy. Is this going to be fixed anytime soon?