How to change the order of the bar chart item

[Anonymous]

Hi all, As seen below, I currently have a bar chart with the x-axis having different statuses. I want to reorder them as they should go New, Vetting, Prioritized, Inflight, Hold.

Is there a way to reorder it?

Thank you for the help!

[PaulDBrown · Accepted solution]

You can include a calculated column in your Status table using:

Order =
SWITCH (
    StatusTable[Status],
    "New", 1,
    "Vetting", 2,
    "Prioritized", 3,
    "Inflight", 4,
    5
)

In the table view, select the Status column and select the "Order column by" option in the  ribbon as select the order column.