Forum Discussion
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?
- 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.
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.
Do you have any news of this?
We've started on it.
This is good news! I deal with a lot of quarterly data, and not being able to create a year-quarter hierarchy is one of the only big limitations with Power BI Desktop.
Since the feature has been started, can you provide a release date for creating hierachies in power bi desktop
I don't know about the release date for creating hierarchies in PBI Desktop, but they are really only a report authoring convenience.
You can achieve identical functionality by just stacking the fields you're interested in in the axis / category / location field well for various visualizations. You can easily add [Year] and [Quarter] to a chart to enable drill down, without having a defined hierarchy on these fields.
