Forum Discussion

Jhadur's avatar
Jhadur
Helper I
2 years ago
Solved

Manual sort of stack column chart

I have created a stacked bar chart that shows the number and status of projects for each executive. Currently it is sorting the status color alphabetically and I need it to sort in Red - Amber - Green order. How can I do that?

 

                 

Status Color = SWITCH(
    [Overall Status],
    10, "Green",
    20, "Amber",
    30, "Red",
    "Unknown"
)

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Jhadur ,

     

    Please try to create a calculated column with number (0-3).

    Status Color = SWITCH(
    [Overall Status],
    10, 3,
    20, 2,
    30, 1,
    0
)

     

    Best Regards,

    Wearsky

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Jhadur ,

     

    Please try to create a calculated column with number (0-3).

    Status Color = SWITCH(
    [Overall Status],
    10, 3,
    20, 2,
    30, 1,
    0
)

     

    Best Regards,

    Wearsky