Forum Discussion
Display matrix of data using PATH function without step duplication when drilling
Hi, Using data from an asset management software, I have been asked to display financial data in an exacting manor compared to the source software. In the source, we have account trees and these tr...
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.