Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello experts,
I have an employee table which has an employee and supervisor relationship. But when I create a hierarchy from the desktop visual by using create hierarchy and add a field to hierarchy , I only get one level direct report, although , for instance , for the CEO, I should have VP->Directors-Managers-Team Leader-Employee.
So, I created a customer hierarchy using path functions. But for some reasons I have blanks at the beginning of each level.
I tried to use Inscope function and use blanks as in the video below but, I still have the blanks.
Remove_Blanks = (SWITCH (TRUE (),
AND (ISINSCOPE (Employee_Hieararchy[DCC Org Level2] ),ISBLANK(SELECTEDVALUE(Employee_Hieararchy[DCC Org Level2]))), BLANK())
Although this seems to hide the blank, I don't know how I can use to work for mor my hierarchy with 8 levels.
Does anyone know what the issue and how I can resolve it?
@Citegetse , refer if the solution given at end of this post can help
https://forum.enterprisedna.co/t/control-blanks-in-hierarchy/19153/16
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |