How to get the hierarchy data to filter the original table?

[afaro]

I organized my data into a hierarchy and I got the identifier for each level. I can see the data in a hierarchy now but I want to be able to see the corresponding details as well of that without having to create multiple columns using LOOKUP. Is this possible? 

[Anonymous · Accepted solution]

Hi @afaro ,

Please check if the following methods can help you get the expected result:

1. Use DAX function PATHITEM:

How to Create an Organizational Hierarchy in Power BI? 

2. Create hierarchy slicer to filter the data:

Add multiple fields to a hierarchy slicer - Power BI | Microsoft Learn

If the above ones can't help you, please provide some raw data in the table with hierachies (exclude sensitive data) with Text format and your expected result with backend logic base on your shared sample data? It would be helpful to find out the solution. You can refer the following link to share the required info:

How to provide sample data in the Power BI Forum

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

[some_bih]

Hi @afaro could you be more precise what is your request.

In general, hierarchy creation could be check on link and related label on second link. Hope this help,