topic Re: How to order the stacks in a stacked bar chart? in DAX Commands and Tips

How to order the stacks in a stacked bar chart?

LyndonTomas — Fri, 28 Apr 2023 07:47:53 GMT

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.

Re: How to order the stacks in a stacked bar chart?

eliasayyy — Fri, 28 Apr 2023 08:54:31 GMT

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

Re: How to order the stacks in a stacked bar chart?

ValtteriN — Fri, 28 Apr 2023 08:57:03 GMT

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/