Forum Discussion
Sankey Chart Customization
Hey all, Im using The Sankey Chart from microsoft and i want to change the order of nodes but i dont know how. Is it even possible to do so?
Thanks for in advance any help or advice.
Hi Swilam ,
You can create a computed column to assign a sort weight to each node for the purpose of changing the order. You can try formula like below:
NodeSortOrder = VAR NodeName = 'Table'[Destination] RETURN SWITCH( NodeName, "Quotes", 1, "Draft", 2, "Sent", 3, "Closed", 4, "Buffer", 5, "Invoiced", 6, "Paid", 7, "Open", 8, 9 )Befor:
After:
Best Regards,
Adamk KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi Swilam ,
You can create a computed column to assign a sort weight to each node for the purpose of changing the order. You can try formula like below:
NodeSortOrder = VAR NodeName = 'Table'[Destination] RETURN SWITCH( NodeName, "Quotes", 1, "Draft", 2, "Sent", 3, "Closed", 4, "Buffer", 5, "Invoiced", 6, "Paid", 7, "Open", 8, 9 )Befor:
After:
Best Regards,
Adamk KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
But if you are using sortorder column in the weight, then how you are using the amount column?
Hi Swilam -Sankey visual from Microsoft, the ability to manually reorder nodes is limited. The nodes are typically ordered based on the flow values or the order in which they appear in your data.
by modifying your data model, adding sorting columns, or exploring custom visuals, you can influence the order of nodes to some extent. If the default Sankey chart doesn’t meet your needs check on custom visual.
Ref:
Solved: Sankey not creating a single node for to and from - Microsoft Fabric Community
Solved: How to use Plotly to create sankey chart - Microsoft Fabric Community
Preparing a data model for Sankey Charts in Power BI (youtube.com)
How to change the location of a node label in a Sankey diagram for Microsoft Power BI? (youtube.com)
Hope it helps.
