Forum Discussion

bblais's avatar
bblais
Resolver III
11 years ago
Solved

Creating Hierarchies in Power BI Desktop Data Model

Is there a plan to add the ability to create hierarchies in the Power BI Desktop data model like there is in the Excel Power Pivot data model, and then make those available to be used in reports?
  • WillT's avatar
    WillT
    11 years ago
    Yes there is :) We're working on this now and we'll have it available in a future release. No firm timelines, but hopefully in the next couple of months.
Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

MichaelP, you can do hierarchies in certain visualizations today in Power BI Desktop. Take a look at adding multiple columns to the "Axis" of a bar or column chart. You will get these little down arrow icons that will let you drill down into the data. Is that what you are looking for?

jt999's avatar
jt999
Regular Visitor
10 years ago

All true...the problem that I have with this is that you (and EVERYBODY else) has to do this each and every time they want to use a hierarchy. Now thats all fine and good when it is a simple hierarchy. But what happens when it is a complex retail or financial services product hiearchy, with many levels? Now every user has to remember the exact order of every complex hierarchy in the organization...

 

Defining a hierarchy once so that everyone can simply drag and drop is actually really important from an end user experience point of view