Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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.
Hi @lbendlin,
This will be the category/subcategory mapping. Only one item contain subcategory. Will it still be able to do?
Thanks so much.
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.
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.
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.