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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

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