Need help to get value from Hierarchy

[sdg1393]

Hi

I am looking for a solution for the following requirement -

I have table with four levels of hierarchy as a columns like Level1 Level2 Level3 Level4 

Sample data level wise - 

Enterprise IT Product Manufacturing 

Enterprise IT Product Electrical

Enterprise IT Support Financce

Enterprise IT Support HR

I have a slicer for individual levels , now I want a comparsob bar chart for current level selection and next level . For example if I select till level 3 one bar will show me the trend (month wise) and another bar will show month wise and next level wise data

for example if I select Product then one bar will month wise KPI ( say sum of val) for product and another bar will show month wise trend of manufacturing and eletrical monthwise trendwhich is at level 4

 
I am good with first part (current level), need to understand how can I get the next level data based on current slicer selection

Note the next level would be dynamic and populate based on the level selection, level 1 slicer selection will show all level 2, level 2 slicer selection will show all level 3 and so on

thanks

- 

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...