Powerbi hierarchy Build

Hi Greg_Deckler 

I posted this in my previous chat as I am anot able to build hierarchy like this the screenshot which is listed below. 

 
So I have one cert_Details in that I have 1 column Owner in that I have hierarchy build like 4 to 5 people in 1 column so I have Separated like Owner 1, Owner 2 , Owner 3 etc so How to build hierarchy like the screenshot listed above in slicer or tree visual in Powerbi.
This kind of problem is not listed above. Can you help me to resolve this..

Hi Anonymous,

Thank you for reaching out in Microsoft Community Forum.

Thank you Greg_Deckler  for the helpful response.

Please follow below steps for required output;

1.Verify that each row in the data correctly represents a parent-child relationship (e.g., Suresh → Ravi).

Example structure:

Owner1 Owner2 Owner3
Suresh Ravi Kiran
Suresh John -
Ravi Kiran

2.Apply the PATH function to create a parent-child relationship:

 HierarchyPath = PATH(YourTable[Owner1], YourTable[Owner2])

3.Use the PATH function to create a calculated column representing the hierarchy and add it to the Fields pane.

4.Drag the hierarchy column into a slicer or TreeViz visual, ensuring the parent-child relationship is set correctly.

Please continue using Microsoft Community Forum.

If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos' to help others find it more easily.

Regards,
Pavan.

Hi Anonymous  

Basically my hierarchy is already built from L1-L15 and I built Hierarchy and Use as visualazation as Matrix and built Tree hierarchy so basically I want to know how we can implement automatic feature suppose If I am searching Justin Manually in my search box in slicer so I want Justin Tree Hierarchy should come below , but now what is happening I have to drill down and search for particular person , help me to solve that problem not like using path functions and all that is basically not solving my purpose.

do let me know 

Hi Anonymous,

Thank you for reaching out in Microsoft Community Forum.

Please follow below steps for desired output;

1.Make sure your data has a structure with columns like Employee and Manager. This allows use of DAX functions like PATH() to build hierarchy paths.

2.Create a HierarchyPath column:
HierarchyPath = PATH([Employee], [Manager])

3.Add a measure to check if the selected person exists in the path:
IsUnderSelectedManager =
VAR SelectedManager = SELECTEDVALUE('Table'[Employee])
RETURN IF(PATHCONTAINS('Table'[HierarchyPath], SelectedManager), 1, 0)

4.Add this measure to your Tree visual or table as a filter where IsUnderSelectedManager = 1. When you search/select "Justin" in the slicer, only his hierarchy (people under him) will be shown.

Please continue using Microsoft community forum.

If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.

Regards,
Pavan.