How to change statcked column order?

[hemingt]

Hello Team,

I have a cloumn named 'status' in my source data table. There are several different values (New, Open, Deliver, Build, Verify, Close).

I use the 'status' to create a stacked column chart to get the count of different status.

The default stacked order is based on the first character of the status value, I want to reorder the stacked, such as move the 'Verify' status to the bottom of the stacked column. Is it possible? Thank you!

[OwenAuger · Accepted solution]

@hemingt 

One way is to create a "Status Index" column (in the Power Query editor).

In your case, you would want the lowest Status Index (say 1) to correspond to Status = "Verify".

Then in the Report or Data view, select the Status column, go to Modelling on the ribbon, choose Sort By Column and select Status Index.

In a quick test at my end, the Status with the lowest Index appears at the bottom of the stacked column.

Does that work for you? Please post back if needed.

[hemingt]

Perfect! Thank you @OwenAuger 

[Anonymous]

Isn't 'V' the last letter anyhow? it should be in the edge.

[hemingt]

Hi @Anonymous , thank you for your reply.

My meaning is that where I can reorder the stacked by myself, such as can I put the Verify status to the mid of the stacked column or anywhere else.