Forum Discussion
Custom Item Hierarchy
All, I am stuck on a project I'm working on. What I am trying to do is create a custom hierarchy for items and am not sure how to model the data. I am currently setting up my table to look l...
abergman -
You should be able to implement similar to https://www.daxpatterns.com/parent-child-hierarchies/
This is a really good article. I read through it, and it seems to be focused on Excel. Does the solution apply to power BI as well? I'm having a difficult time implementing in Power BI. I created the PATH column, but don't know what to do after that.
Power Pivot uses DAX. Yes it applies to Power BI.
Are you reviewing the Complete Pattern? The only other bit that's not in the article, it's in the comments, is :
BrowseDepth:= ISFILTERED ( Nodes[Level1] ) + ISFILTERED ( Nodes[Level2] ) + ISFILTERED ( Nodes[Level3] )MaxNodeDepth:=MAX ( Nodes[HierarchyDepth] )
If I recall correctly.
Then you'll make your own hierarchy to drag and drop Levels.
How do I set up the nodes key and parent key for my table?
