Forum Discussion
Solved
How do I create Sankey Chart from two table data?
We have following two tables "Shop Transaction" and "Organization Tree". Use PowerBI desktop to create a Sankey chart using these data. Note that: When a shop is added or a shop changes distri...
Step 0: I use these DATA Tables below. (I add some dammy data to 'Shop Transactions' table.)
Step 1: I add a column to these 2 tables each.
Step 2: I merge 2 tables.
- Before -
- After -
Step 3: I sort 'Shop Transactions' table with 'shop no' column and 'date'column.
Step 4: I fill down 'Parent' column.
Step 0: I use these DATA Tables below. (I add some dammy data to 'Shop Transactions' table.)
Step 1: I add a column to these 2 tables each.
Step 2: I merge 2 tables.
- Before -
- After -
Step 3: I sort 'Shop Transactions' table with 'shop no' column and 'date'column.
Step 4: I fill down 'Parent' column.