Creating a path hierarchy for drilldown

[Jano]

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

[mwegener · Accepted solution]

Hi @Jano 

look at this.

https://www.youtube.com/watch?v=x6vXVJZ_eTY

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[Jano]

Yeah thank you, that cleared my mind again.

I already was at that point but didnt realize it 😄