Decomposition Tree

[Anonymous]

Hi, I was new in Power BI and try to figure out the method of decomposition tree. 

I have the category and subcategory table, the first table is just category and second table is subcategory table

My issue is how should I connect the subcategory table to the category table, so that the time I press into the flow 5 just shown incoming and outgoing, and in the incoming will include basement and the basement will shown the subcategory value. 

The decomposition tree now shown the blank and it will shown the subcategory but in the incoming will not shown that. 

Thanks so much for your help. 

[Anonymous · Accepted solution]

Hi @Anonymous ,

Have you tried to join the two tables with a relationship?

Create and manage relationships in Power BI Desktop - Power BI | Microsoft Docs

Decomposition tree - Power BI | Microsoft Docs

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.