Need help to get value from Hierarchy

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

-