Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Column Chart Legend Order - reversed

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...
Need Help
  • Icey's avatar
    Icey
    6 years ago

    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.

Icey's avatar
Icey
Community Support
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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