Forum Discussion
Using PATH(), How Do I Remove Blanks From My Hierarchy Between Levels?
Hello awesome communty! I'm learning the PATH() function, what I'm doing is, I want to create a product category hierarchy, I'm getting a table from Dynamics 365 F&O called "RetailProductHierarch...
HI I_NeedMorePower,
I'd like to suggest you replace the first level parent field as itself value, current path function seems not works if parameter fields has null value.
Regards,
Xiaoxin Sheng
Hello there!
I tried what you suggested to me, to make the parent of the root the same name instead of null, but it gave me the same result.
It seems if I wanted to remove the blank leaves is only by using the heirarchy slicer with turning off the "empty leaves" option.
Thank you for your time to help :)