Forum Discussion
Sankey in Power BI
Super UserHi Trump ,
To create a Sankey chart in Power BI with the provided data, where the source (Source_NEW) and target (Target_NEW) columns may contain duplicates or identical values (e.g., "A"), you need to prepare the data and configure the visual correctly.
First, ensure the data is organized with source, target, and volume columns in a single table. If source and target values are identical, you can add a prefix or suffix to distinguish them, such as "Source: A" and "Target: A." This helps avoid visual clutter in the chart.
Sankey in Power BI
Once the data is prepared, install the Sankey visual from the Power BI visuals store. In the chart, drag the source column to the Source field, the target column to the Destination field, and the volume column to the Weight field. Adjust the formatting options, like node separation, to enhance chart clarity.
Bibiano_Geraldo Thank you for response, but still its not solving the issue. Can ellaborate and share table to undersatdn this in detail?
- Rupak_bi
please share sample data with exact reprsentation of your original dataset structure. source and target can be same at different rows if you have three or more level of hierarchy.
Rupak_bi Bibiano_Geraldo - Here is my data, in an excel
Could you please help me further?
Thank you in advance.
Source_NEW Target_NEW Volume_delivered A A 385246807 A H 41479873 A I 200607 A L 104966797 B A 3328827 B H 1888163 B G 171801 B J 6810 B K 2594 B M 431748761 B N 96554 A N 54809263 A M 21131962 C A 142886 C F 167298228 C G 402417 C K 104716 C O 1881 A C 1045469 A K 3823443 A F 7416088 A D 55242475 D H 615274 D A 103629080 D E 206967 D O 103434 D K 2366107 D M 19366026 D N 64967624 D L 2765977 A O 10013330 E D 126630592 F A 53996987 F O 36911752 F J 23435679 F H 51756392 F K 5709542 F C 487793 F D 1764 F N 126317 A J 182905 G O 219151608 G A 65814765 G H 58402982 G J 15972177 G K 10320708 H A 368765868 H O 88437135 H J 66087612 H K 32856557 H I 4196223 H G 95597 H D 17688 H F 376 H C 576 H N 363317442 I A 51968097 I H 4323972 I L 117574967 J H 97970758 J O 16389844 J K 3284445 J A 17119133 J N 175571060 A G 466695 K A 54886748 K H 231434 K C 2967 K J 32775 K F 61
