Sankey Chart Customization

[Swilam]

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.

[Anonymous · Accepted solution]

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 Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Palak001]

But if you are using sortorder column in the weight, then how you are using the amount column?

[rajendraongole1]

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.