cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ChrisEby Frequent Visitor
Frequent Visitor

stacked column chart legend order

I have a stacked column chart with the legend placed on the right:

 

StackedColumnChart.jpg

 

As you can see, the columns build up from the bottom, alphabetically by Category.  However, the legend shows the exact opposite order.  I may be missing something simple, but how can I get the stacks and legend to line up in the same order (without turning it into a horizontal stacked bar instead of stacked column)?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: stacked column chart legend order

Hi @ChrisEby,

 

That's really a good idea. I'm afraid it's limited for now. I would suggest you vote up these ideas.

custom-order-for-legend-in-stacked-bar-chart

power-bi-ideas/suggestions

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Community Support Team
Community Support Team

Re: stacked column chart legend order

Hi @ChrisEby,

 

We can sort the legend column [Change Reason] in the original table. Then the order will be applied in the visual. Please give it a try.

1. Create a proper order column if you don't have one.

2. Change the sort order by "Sort by column".

3. Done. Please refer to the snapshot below.

stacked_column_chart_legend_order

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ChrisEby Frequent Visitor
Frequent Visitor

Re: stacked column chart legend order

@v-jiascu-msft,

 

Can you please change the Legend position in your example from "top" to "right" and send another screen shot to illustrate that the order of the legend does indeed match the order of the stacked columns?  I'm not trying to change the sort, I'm trying to get the legend and stacked columns to visually agree.

Highlighted
Community Support Team
Community Support Team

Re: stacked column chart legend order

Hi @ChrisEby,

 

That's really a good idea. I'm afraid it's limited for now. I would suggest you vote up these ideas.

custom-order-for-legend-in-stacked-bar-chart

power-bi-ideas/suggestions

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.