Forum Discussion

tim_001's avatar
tim_001
Helper I
2 years ago

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 pos...
Need Help
tim_001's avatar
tim_001
Helper I
2 years ago

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. 

lbendlin's avatar
lbendlin
Super User
2 years ago

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.

  • tim_001's avatar
    tim_001
    Helper I
    2 years ago

    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 🙂