Sankey in Power BI

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