Column Chart Legend Order - reversed

[Anonymous]

Hi Power BI Experts,

I have a silly question, the resolution is probably very easy, but I am missing something.

The thing is I want to have my right-placed legend ordered in proper way and the only thing I could accomplish at the moment is to have it reversed:

As you can see on the legend the label Done is on the top, while in the chart it's on the bottom. I used the Sort by Column option with previously created Sort column (the workaround from many solutions found on this forum). What am I doing wrong? If I reverse the Sort column, everything reverses, so again the label Done in legent is on the bottom, while on the chart is on the top.

Could you please advise?

Thanks in advance!

Karol

[Icey · Accepted solution]

Hi @Anonymous ,

I apologize for my previous misunderstanding of your question.

I did not find a direct solution. But there is a workaround:

1. Copy your Stacked Column Chart and convert it into a Pie Chart.

2. Then click the "..." and choose to sort Z-A of your Pie Chart legend.

3. Keep only the legend of the Pie Chart.

4. For the two charts, turn the background off.

5. Put the Pie Chart behind the Stacked Column Chart.

Best Regards,

Icey

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

[Anonymous]

Hi @Icey,

This is great! Very original idea and it works! Thank you very much!

BR, Karol

[parry2k]

@Anonymous if you click on 3 dots on top right corner of the visual, what is the sort order there? Can you double check that?

[Anonymous]

@parry2k The sort order under those three dots impacts Y axis, not the values inside each bar. What I am trying to achieve is to have the same order inside each bar (on X axis) as is in the legend.

[parry2k]

@Anonymous not necessarily, can you expand sort order of those 3 dots and share what it is?

[Anonymous]

@parry2k Sorry my bad, I confused the axis. What I meant is that those three dots are changing order of the bars on X axis, and I want to change categories order inside each bar to be matching with the legend.

Here are the options I have under three dots:

Here is what happens to the visualization when I change for example order to descending and sort by Count of Category:

Here is what I mean. You can see that on the legend, color representing Done is on the top, while in the bar it is on the bottom. So either Done label in the legend should be on the bottom or color representing category Done should be on the top.

I have sorted it using adittional "Sort" column workaround (https://www.seerinteractive.com/blog/reorder-powerbi-legend/).

[Icey]

Hi @Anonymous ,

Glad to hear that you have solved your problem. Please accept your reply as a solution so that people who may have the same question can get the solution directly.

Best Regards,

Icey

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

[Anonymous]

Hi @Icey, @parry2k 

I don't understand, how is my problem solved? I don't see any solution after my last post...

Let me describe the problem once more. I want to have legend in the same orders as the colors inside each bar as shown on the picture below:

The picture shows how it looks now. You can see (marked with black line) that value "Done", so blue color, is in the bottom inside bar while it is on the top in the legend (the blue circle with label "Done" is on the top). You can also see that every color is in reverted order in the legend (light-purple is on top in the bars, while it is in the bottom in the legend, then purple is the second one from the top in the bar, and second-last in the legend and so on...). 

The red line shows how it should be. The blue color representing "Done" should be either on the top inside the bar (because it is on the top in the legend) or on the bottom in the legend (because it is on the bottom inside a bar). 

It is just about changing order of the legend, it should be basic functionality, I just can't find it anywhere...

Please let me know if my issue is still hard to understand, I will try to explain it once more...

BR, Karol

[parry2k]

@Anonymous sounds good. it is sorted out. I was going to head to that kinda solution.