Forum Discussion
Display matrix of data using PATH function without step duplication when drilling
ctaylor , I did not get it. Refer if this can help
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
That link just gives further insight into what I am already doing. I am already creating the path, then chunking out the individual levels.
The problem is this....
Let's say a line item "Fake $" has a hierarchy level of 6. It has six rollup items above it. There is no 7th and no 8th level. If I expand the matrix all the way out to the 8th level, there will be 3 cascading line items that say "Fake $", because the example I got this idea from didn't want to leave blanks for whatever reason.
Level 2 = IF('GL Nodes Community'[Hierarchy Depth] >=2, LOOKUPVALUE('GL Nodes Community'[NameKey], 'GL Nodes Community'[NodeKey], PATHITEM('GL Nodes Community'[Hierarchy Path], 2, INTEGER)), 'GL Nodes Community'[Level 1])
If I use what's in the link you posted, then I get "Fake $" in Level 6, then blanks in 7 and 8.
I need it to stop expanding at Level 6 for the item "Fake $" because there is no more new nodes to jump to after that point.
Do I need a measure or something set to 1 or 0 to somehow display the items up to their max depth?
I found a solution that gets me 99% to where I want to go.
https://www.sqlbi.com/blog/alberto/2011/07/19/parent-child-hierarchies-in-tabular-with-denali/
I built the browsedepth and nodedepth measures and then incorporated them into my larger measures to calculate the amounts to blank out then hide columns that exceed the browsedepth.
The only thing that still happens is there are +/- icons at the lowest level of data if it happens before Level 8.
Any thoughts on how to fix this final visual issue?
Hi,
you might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive for business and share the link to the file.
