Forum Discussion
Hierarchy with non aggregated values
HI HassanI,
Can you please share a pbix file to test? I'm not so clear for your data.
In addition, I'm not so sure why you drill all parent level code to bottom level, it may conflict your 'parent-child' relationships.
BTW, parent-child hierarchy relationship not works with tables who link with normal relationships, if you want to auto summary child level data to parent level, you need to manually extract child items from marketer table.
Regards,
Xiaoxin Sheng
What is the best method for me to share a PBIX file with you?
HI HassanI,
I have some trouble to access the your file, please upload to onedrive or google drive and share link here.
Notice: do mask on sensitive data before sharingReagards,
Xiaoxin Sheng
HI HassanI,
After I remove non existent child code and rebuild hierarchy, your visual graph can be drilled again.
Regards,
Xiaoxin Sheng
Hi as I mentioned, the drillthrough was already working fine, the issue was the values field "YTD vs plan %". If I'm looking at level 1 we have one code 4911, it's YTD vs Plan % in the data is -1.85% which is the value I want to display against 4911. Not the aggregated value of everything under it. When I click to drilldown on 4911 it opens level 2 cost centres related to 4911 such as 4216, 4428, 5691....and so on. For each of these i want to pull the specific ytd vs plan % not the aggregated value.
Hi HassanI,
I don't think this issue simple to achieve, visuals will auto summary it's child values.
For your requirement, you need to add condition to check current hierarchy levels, then break current summary and manually coding formula to get specific value with filters to get data from particular level.
It should be complex and hard coding.
Regards,
Xiaoxin Sheng