Forum Discussion

Swilam's avatar
Swilam
Regular Visitor
2 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

     

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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's avatar
    Palak001
    New Member
    6 months ago

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