Manual sort of stack column chart

[Jhadur]

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"
)

[v-xiaocliu-msft · Accepted solution]

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