decomposition tree

[Anonymous]

Hi friends

I one new requirement in my company

One table have dataset where in one column only I have the userid of the person who  is sending the product and in the same column I have the user id of the person who got the product,

How to show this in Powerbi,

Below is the image of the sample dataset

You can see who is sending to who based on color,

And also in real database we have huge dataset, so how to do that in that case

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[Anonymous]

Hi @lbendlin ,

i am sending the below data set with remove sensetive information.

Below is the sample dataset, you can copy the below table and paste in the normal excel

Table:

TreeNodeNumber	Role	UserID	EmpName	Parent Id	OrganizationName	ItemQunatity	Available Quantity
0	Organization	0	TEST-ORG		TEST-ORG	2000	500
1	Distributor	1	Abc	0	TEST-ORG	1100	50
2	Retailer	2	Antonio Moreno	1	Abc	350	150
3	Retailer	3	Aria Cruz	1	Abc	350	300
4	Retailer	4	Dinesh Raturi	1	Abc	350	50
5	Distributor	5	Matt	4	Dinesh Raturi	100	200
6	Retailer	6	Jhon	4	Dinesh Raturi	200	200
7	Distributor	7	Jacobs	2	Antonio Moreno	100	200
8	Distributor	8	David	2	Antonio Moreno	50	50
9	Distributor	9	Matt	7	Jacobs	100	200
10	Distributor	10	Meena	8	David	400	200
11	Retailer	11	Seema	10	Meena	200	200

and out will be like below

[lbendlin]

You could use one of the hierarchy visuals

or you can consider using the Sankey diagram

or a more fancy version.  Decomposition tree is an option but that would require you to pivot the data and hard code the hierarchy levels.

[Anonymous]

ok but suppose i have one more person to whom the 3rd (person antonio) is sending to Matt(4th level) in hierarchy visuals, how it will be connected, and shown?