Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Decomposition Tree

Hi, I was new in Power BI and first time using decomposition tree method.  I have a list of data  Incoming water  timestamp Main water Basement  admin washer bin 30/5/22 34 23 12 45...
Need Help
Show and Tell
  • lbendlin's avatar
    lbendlin
    4 years ago

    Unpivot your data to bring it into a usable format. Then you can consider putting incoming and outgoing in the same table so you can use a Waterfall (haha, funny)  chart too.

     

    see attached for a sample.

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi lbendlin, 

This will be the category/subcategory mapping. Only one item contain subcategory. Will it still be able to do? 

 

Thanks so much. 

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

yes, that will work.  You will need to report on subcategory level for all categories. Meaning you cannot provide values for Basement and for City Water, you can only provide it for City Water and do the rollup to Basement automatically.