Forum Discussion
Visualize Data in Matrix Table based on Dropdown - Issue with Dropdown
Dear Community,
I am having some issues with visualization of a matrix table. I hope it can be solved either with changing the layout of the visual or with an additional measure. There is no possibility to change the data set much.
DATA:
Product Group | Product | Match Level | Stock Keeping Unit (SKU) |
Fruits | Apple Red | Level 1 | 10012 |
Fruits | Apple Green | Level 1 | 10145 |
Fruits | Apple Yellow | Level 1 | 10784 |
Vegetables | Tomato | Level 1 | 10185 |
Vegetables | Tomato | Level 1 | 10156 |
Fruits | Banana | Level 1 | 10151 |
Fruits | Apple Red + Green | Level 2 | 10012 |
Fruits | Apple Red + Green | Level 2 | 10145 |
Fruits | Apple Red + Green | Bundle | 10121 |
- Stock information is taken from another table linked to the SKU.
AS-IS:
- DropDown with single select by Product.
- Matrix Visual to show stock by Product:
Current Visual Result when selecting Product "Apple Red + Green":
Product | Stock |
Apple Red + Green | 3643 |
Issue: I cannot see how it is split down.
TO-BE:
- DropDown with single select by Product.
- Matrix Visual to show stock by Product:
Example "Apple Red + Green" how it should look like:
Match Level | Product Group | Stock |
Bundle | Apple Red + Green | 23 |
Level 2 | Apple Red + Green | 234 |
Level 1 | Apple Red | 56 |
Level 1 | Apple Green | 63 |
--> The idea is to see how many we have in the different levels. They should not all be summed up but just the total of all the SKUs linked to the same Product.
Example "Apple Red" how it should look like:
Match Level | Product Group | Stock |
Bundle | Apple Red + Green | 23 |
Level 2 | Apple Red + Green | 234 |
Level 1 | Apple Red | 56 |
Level 1 | Apple Green | 63 |
--> The idea is to see how many we have in the different levels. They should not all be summed up but just the total of all the SKUs linked to the same Product.
The Challenge:
- I am not sure how to visualize it as the single select dropdown lets me select only one product name. But to make it multiple select is not working as I don´t know which product has how many levels.
Maybe there is something I am overseeing or a trick that some of you might know how to get it working.
Looking forward to your replies and as always thanks for any inputs 🙂
Kind Regards Tim
6 Replies
There is no possibility to change the data set much.Your data is not in a format that is usable in Power BI.
Thanks a lot for the feedback. Do you know how I could restructure the table to get the desired result?
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).
