Forum Discussion
Column Chart Legend Order - reversed
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.
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/).
Anonymous sounds good. it is sorted out. I was going to head to that kinda solution.