Sankey Chart

[JudMS]

Hi, 

I created a Sankey chart. I set up "duplicate" under the cycles displaying option. However, the chart does not duplicate the Source and the Destination. Two of them are single and links going both directions which is not ideal. 

What else do I need to do to be able to see data on both sides, please? Thank you for your advice. 

[rajendraongole1 · Accepted solution]

Hi @JudMS -The "Duplicate" option under the cycles displaying option should theoretically resolve the issue, but if it doesn't then we should follow some additional things like data structure with distinct source and destincation values.avoid cycles if possible.Sankey diagrams generally work best when there are no cycles, as these can complicate the flow visualization. If cycles are unavoidable, you may need to adjust how your data is presented.

Can you check the below youtube link explains step by step how you should tackle this sankey chart.

https://www.youtube.com/watch?v=dNrXOAfX6CM&t=859s

ref:

Solved: How do I create Sankey Chart from two table data? - Microsoft Fabric Community

hope it helps

Hope it helps.

[JudMS]

Thank you. There is food for thought. Yes, there is a cycle as I have 12 teams who provide and request support between themselves. 

Also, thank you for the YouTube link, much appreciated. 

I have some work to do. 🙂