Need help to get value from Hierarchy

sdg1393 — Wed, 06 Sep 2023 16:11:03 GMT

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

Re: Need help to get value from Hierarchy

lbendlin — Mon, 11 Sep 2023 01:47:23 GMT

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-Forum/ba-p/963216
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/1447523

topic Re: Need help to get value from Hierarchy in DAX Commands and Tips

Need help to get value from Hierarchy

Re: Need help to get value from Hierarchy