Forum Discussion

rolf1994's avatar
rolf1994
Icon for Helper II rankHelper II
9 years ago
Solved

Sort legend in different way

Hi,   When creating a stacked column chart with a legend I get the following result:   As you can see, the legend sorts from top to bottom (1 to 5) and the stacked column sorts from top to ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi,

     

    I had a quick play and couldn't find any way of changing the sort order of the legend independently of the stacked bar.  

     

    Achievable with layered visualisations though:

     

    Can send you the .pbix if you need it?

     

    Cheers

     

    Mark

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi,

 

You're lucky.... I still have it!

 

PM me your email address and I'll send it on....

 

Cheers

 

Mark

Amy's avatar
Amy
New Member
8 years ago
Hi the BIbutler,

I am facing the same issue. I hope I am lucky too to get the .pbix file.

Great thanks.
Amy
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Sure, PM me your email address.

     

    Is there anyway of attaching it in here does anyone know?

    • Shefik's avatar
      Shefik
      Frequent Visitor
      8 years ago

      In case anyone is looking for a workaround...

       

      Create a stacked bar chart, and put the legend where you want it.  It's backwards.  Ugh.  Great.

       

      Now copy/paste the visualization and convert it into a pie chart.  Click the "..." and choose to sort Z-A of your legend.

       

      Now get rid of the legend in your bar chart and turn the background on, and set the transparency to 0%.

       

      Now for the magic: PUT THE PIE CHART BEHIND THE BAR CHART, and leave the pie chart's legend sticking out.  Ta-da!  You now have a stacked order that matches your legend order.

       

      "But Shefik," you immediately say.  "That's all well and good, but now the stack AND the legend are both backwards."  That's where I tell you to pray to the Power BI gods and hope that they make the legend order configurable in a future monthly release.  This is the best I can do for you.