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, 

From the flow that you make, are there any chance to include subcategory? Such as by pressing the plus symbol will show the subcategory of the amount. 

 

Thanks a lot. 

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

That is technically possible but your sample data is inconsistent (I had to move stuff aroud to make it work and fix spelling differences too). Provide a better category/subcategory mapping, and then I can help with the visual.