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.
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.
I would be happy with your answer that this is just convenience if that would be true...
But this is not. Example:
Can you explain how then to add on this the hierarchy I would like to use (Service Departments -> Projects) ? Ho. I can past screenshot.. Nice.
So Area Diagram, X-Axis "dates", Y-Axis: "Amounts", Legend: "Service Departments".
Can you add to Legend in area charts "Projects" to have the drilldown from "Service Departments"?
On my experience: NO.
Context: Tabular Model, Analysis Service
