Change Order of Stacked Bar

[alex4597]

In this line and stacked column chart I want the red bar to be on top of the green one, is there a way to do that?

[v-kelly-msft · Accepted solution]

Hi  @alex4597 ,

First go to query editor,then add column> columns from example to add a column as below:

 #"Added Conditional Column" = Table.AddColumn(#"Changed Type", "Custom", each if [Color] = "red" then 2 else if [Color] = "green" then 1 else null, type number)

Then back to data view>select column color>sort by column;

 

And you will see:

beforeafter

For the sample .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[negi007]

@alex4597 You can do this by creating an another table like below and then link it to main table using color column.

Then you can do the sorting using the newly created column like below and have your chart legend in your desired sequence

[amitchandak]

@alex4597 , Change the color from data Color.

Or Create a new sort column the current legend that will reverse the sort order and mark that as the sort column

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column