Forum Discussion
Creating Hierarchies in Power BI Desktop Data Model
- 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.
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?
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
- To everybody on this list, the PowerBI team only released the hierarchy feature from a design point of view to aide with development. It is not intended to work for filtering as yet. This is the next step for the PowerBI team as it is currently under review.
The PowerBI team is very agile and they tend to get ahead of themselves and release an unfinished feature in segments in order to please the community. However this does have drawbacks when the community expect the feature to be the solution to everything. I have been caught out myself thinking a feature is complete when it is only a part rollout.
I guess we can either wait 3 months for a partial solutin that will satisfy some people, or wait 6 months for a full solution with nothing in the interim.
I haven't seen a BI company this agile in development and listening to the community. Yes, they might have a rollout strategy that annoy us, but they are listening.
Daniel Hierarchies can currently only be consumed from SSAS. For a time it was (maybe still is?) SSAS MD only.
Consumed from SSAS?
I believe we have not the same level of expectations. Created hiearchies from Tabular Model are exploded as separate fields.
Useless.
Agree with Miclael.
We have graet demand of custom Hierarchy with simplyness and effciency! it's a MUST HAVE feature!!! VERY DISPOINTED
At least should have the same as in powerPivot.
