Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
Yeah thank you, that cleared my mind again.
I already was at that point but didnt realize it 😄
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |