Satya Vaitla on 24 Apr 2016 01:04:25
in data model, creation of self join hierarchy should be available like employee and reporting manager hierarchy
- Comments (1)
RE: self joined hierarchy
Yes! Many of our dimensions are parent/child hierarchies.
I'd like for Power BI to support creating true parent/child hierarchies, in a table. (In addition to the current hierarchy functionality, where you create a hierarchy by picking the set of columns, in order, that constitute the hierarchy.)
Then, all of the visualizations that can use hierarchies, like Matrix, Bar Charts, etc. should just "do the right thing" with parent/child hierarchies.
I think this is the most important feature request out there, right now! It would be such a bigger deal than any of the feature requests that currently have 1,000+ votes.
There have been several copies of this "idea" created, with keywords like "parent/child hierarchies," "self-referencing hierarchy," "self joined hierarchy" and "ragged hierarchy." Maybe they could be merged?