Forum Discussion
Visualize Data in Matrix Table based on Dropdown - Issue with Dropdown
You have many options to represent your ragged hierarchy - Here is one example (and it links to others)
Parent-Child Hierarchies with multiple parents in Power BI with Power Query (thebiccountant.com)
The table structure (and the data model) ultimately have to follow the user requirements. So if you need to be able to filter by product then you need to have a product column at the atomic level (and the associated hierarchy).
Thanks a lot. It looks like I need to spend some time to figure it out in detail but I get the idea.
Is it correctly understood that first step would be changing the table to look similar like that?:
Because I have the data in a data-base friendly format, could I not create another table in Power BI itself and make a function if it is Level 1 then put it in the columne, otherwise empty?
I am just asking because it was mentioned that I would need to change my dataset but if I could do it like that, then I would not have to change the data set but only transform it into another table. Not sure if it will work 🙂 It sounds a bit too optimistic from my end. Thanks a lot again for the tips and links.
Something similar to your example (although not your geographical choices 🙂 ) may work. You are dealing with a scenario that has both multiple parents AND a ragged hierarchy. So you need to accommodate both when you transform the data.
Thanks so much. Yes, I think I am getting there. It looks like this now:
Product
Stock Keeping Unit
Level 1
Level 2
Bundle
Apple Red
10012
Apple Red
Apple Red + Green
Apple Green
10145
Apple Green
Apple Red + Green
Apple Yellow
10784
Apple Yellow
Tomato
10185
Tomato
Banana
10151
Banana
Apple Red + Green
10121
Apple Red + Green
The challenge is now on the Apple Red + Green with a new SKU. So I am not sure how to apply it to the new table format. But maybe I also did not understand the nodekey exactly.
Any ideas are appreciated 🙂