Sankey in Power BI

[Trump]

How can I create a SANKEY in POwer BI with below data?  I tried a lot with Add-in but the problem is as follow;

The SOURCE and TARGET is same hence grafik is not coming clearly. For example A. 

Thank you in advance for assistance. 

Source_NEW	Target_NEW	Volume
A	Other	385246807
B	M	41479873
C	N	200607
D	O	104966797
E	A	3328827
F	P	1888163
G	Q	171801
H	R	6810
I	E	2594
J	S	431748761
K	T	177149735
	U	199606477
	V	222063219

[suparnababu8]

Hi @Trump 

Creating a Sankey chart in Power BI can be tricky when the source and target are the same, but it is possible with some adjustments.

To avoid confusion when the source and target are the same, you can add a prefix or suffix to distinguish them. For example, you can create new columns in your data:

Source_Modified = "Source: " & [Source_NEW]

Target_Modified = "Target: " & [Target_NEW]

After adding columns- your data table look like this..

Then,
1. Add the Sankey chart visual to your report canvas.
2. Drag the Source_Modified column to the Source field.
3. Drag the Target_Modified column to the Destination field.
4. Drag the Volume_delivered column to the Weight field.

After this your sankey visual like this.

By following the above process, you should be able to create a clear and informative Sankey chart in Power BI, even with identical source and target values. Let me know if it works. Thanks

[Bibiano_Geraldo]

Hi @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.

[Trump]

@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. 

[Trump]

@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