Forum Discussion

ctaylor's avatar
ctaylor
Icon for Helper III rankHelper III
6 years ago

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...
Need Help
ctaylor's avatar
ctaylor
Icon for Helper III rankHelper III
6 years ago

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?

 

 

v-diye-msft's avatar
v-diye-msft
Icon for Community Support rankCommunity Support
6 years ago

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.