https://community.fabric.microsoft.com/t5/Developer/Creating-Hierarchy/m-p/3698854#M49536 <P>I have 3 columns in my dataset, "Employees code", "Employees names", "Reporting manager". I want to create a proper hierarchy, but when putting in slice, it's coming only one step hierarchy. How to solve ?</P><P>&nbsp;</P> Wed, 14 Feb 2024 13:23:05 GMT _Su 2024-02-14T13:23:05Z https://community.fabric.microsoft.com/t5/Developer/Creating-Hierarchy/m-p/3698854#M49536 <P>I have 3 columns in my dataset, "Employees code", "Employees names", "Reporting manager". I want to create a proper hierarchy, but when putting in slice, it's coming only one step hierarchy. How to solve ?</P><P>&nbsp;</P> Wed, 14 Feb 2024 13:23:05 GMT https://community.fabric.microsoft.com/t5/Developer/Creating-Hierarchy/m-p/3698854#M49536 _Su 2024-02-14T13:23:05Z https://community.fabric.microsoft.com/t5/Developer/Creating-Hierarchy/m-p/3700664#M49549 <P>Hi&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/684421">@_Su</a>,</P> <P>After I test with slicer, it found it seems not support auto drill to the button and show all columns fields, perhaps you can submit an idea for this requirement.</P> <P><A href="https://ideas.fabric.microsoft.com/" target="_blank">Microsoft Power BI ideas</A></P> <P>If you mean to create hierarchy structure in power bi, you can refer to the following link:</P> <P><A href="https://www.youtube.com/watch?v=x6vXVJZ_eTY" target="_blank">How to create and use a Power BI Hierarchy - YouTube</A></P> <P>Regards,</P> <P>Xiaoxin Sheng</P> Thu, 15 Feb 2024 08:34:59 GMT https://community.fabric.microsoft.com/t5/Developer/Creating-Hierarchy/m-p/3700664#M49549 Anonymous 2024-02-15T08:34:59Z https://community.fabric.microsoft.com/t5/Developer/Creating-Hierarchy/m-p/3705490#M49595 <P>What is a "proper hierarchy" ?&nbsp; Have you tried the PATH functions?</P> Sat, 17 Feb 2024 21:37:55 GMT https://community.fabric.microsoft.com/t5/Developer/Creating-Hierarchy/m-p/3705490#M49595 lbendlin 2024-02-17T21:37:55Z