Creating a path hierarchy for drilldown

Hey there,

I'm nearly done exploring the PATH functions in power bi to create a hierarchy of my category table.

But it seems like I can't figure out the last step on how to create the hierarchy so I have drilldown possibilies in visuals like a matrix.

my current table is like this:

category_id | parent_id | category_path | category_path_level | level_1| level_2| level_3 | level 4

I use PATH, PATHLENGTH and PATHITEM to create the path columns.

How to create the hierarchy now, so I can use a proper drilldown function?

Hope you guys can help me here!

Best regards,

Jano