How to order the stacks in a stacked bar chart?

[LyndonTomas]

For context, I have a Power Bi report connecting to a Share Point list. For this one, I have a stacked bar chart containing the Status of each department. In my list, there are 2 columns "Status" and "Department". How can I order the stacks ina specific order based on this sequence, group by "Completed", "In-Progress", "Not Started", "On-Hold", "Cancelled".

Here is the bar chart for reference.

[eliasayyy · Accepted solution]

create a new column in your table called order

order = SWITCH( 
               TRUE(),
               "Completed",1,
               "In-Progress",2,
               "Not Started",3,
               "On-Hold",4,
               "Cancelled",5
)
                       

after that, press on the column where you have the status and in the toolbar you will find "Sort Columb by",

press it and choose the "order" column

now go to your stacked report and sort by status ascending

[ValtteriN · Accepted solution]

Hi,

The legend sorting can be changed by chanhing the sort order of the column in your table. E.g.

Data:

No sort:
(A to D)

Sort by column2:
(D to A)

So in your case you can create a new column with values for department statuses (e.g. numbers 1 to 5) and use that for sorting.

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[eliasayyy · Accepted solution]

create a new column in your table called order

order = SWITCH( 
               TRUE(),
               "Completed",1,
               "In-Progress",2,
               "Not Started",3,
               "On-Hold",4,
               "Cancelled",5
)
                       

after that, press on the column where you have the status and in the toolbar you will find "Sort Columb by",

press it and choose the "order" column

now go to your stacked report and sort by status ascending