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

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.