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 "RetailProductHierarchyCategories" it has a "CategoryName" field and "ParentCategoryName" field.

I want to create a hierarchy for this so I made a new column called it PATH and it has this value:

Path = PATH(RetailProductHierarchyCategories[CategoryName];RetailProductHierarchyCategories[ParentCategoryName])

And then, since the hierarchy in my D365 F&O has 6 Levels, so I created 6 new columns named CategoryL1,2,3...6 and their values are as follows:

CategoryL1 = PATHITEM(RetailProductHierarchyCategories[Path];1)
CategoryL2 = PATHITEM(RetailProductHierarchyCategories[Path];2)
....
CategoryL6 = PATHITEM(RetailProductHierarchyCategories[Path];6)

After that, I created a new hierarchy column and dragged the 6 columns in this new hierarchy column.

And here is the result I got:

I got the hierarchy right except it includes blanks for each level till the 6th level.

For example, some categories has only 3 levels, but it includes blanks to each level till the 6th level.

How do I make PATH() to stop at the last possible level, I mean if this category has 4 levels, I want it to stop at level 4 and shows those 4 levels only and not go deeper with blanks?

The hierarchy slicer has a toggle called "Empty Leaves" but it does not filter the blanks on other visual types.

How can I resolve this issue? or what I've done wrong?

Thanks in advance! :)