Decomposition Tree

[Anonymous]

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	23
3/6/22	45	34	34	67	45
3/6/22	56	45	56	89	67

outgoing water 

timestamp	waste 1	waste 2	waste 3
30/5/22	234	234	234
3/6/22	345	345	567
3/6/22	34	456	45

Data list

type	category	subcategory
incoming water	basement	admin
incoming water	bin
incoming water	washer

type	category
outgoing water	waste 1
	waste 2
	waste 3

for the decomposition tree, 

I may need the sum of the main water > each category in incoming water by showing the sum in the timestamp (may use slicer to pick the date)> each subcategory also shown the sum 

sum of all the incoming water > each outgoing water category with the sum in timestamp table 

I will appreciate for your help. 

Kind regards, 

Kim. 

[Anonymous]

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]

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.

[lbendlin · Accepted solution]

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]

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]

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.