Forum Discussion

rolf1994's avatar
rolf1994
Helper 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 bottom (5 to 1).

 

I think analyzing the stacked column if the legend was sorted from 5 to 1 would be much easier, is there a way to do this? I want the legend positioned on the left.

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

10 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    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

    • rolf1994's avatar
      rolf1994
      Helper II
      9 years ago

      Thanks for your reply!

       

      That looks the way that i want it. I would like you to share your .pbix if possible but one thing:

       

      If you did it by creating a measure for 1, 2, 3... then unfortunately it is not going to work in my case because the legend is going to have over 1000 different measures, depending on the filters selected.

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Yeah needed a couple of additional columns.  Are your 'measures' in your legend numbers?  There must be some formula/easy way to reverse the order which is all you need for this?

         

         

    • branndicoot's avatar
      branndicoot
      Regular Visitor
      8 years ago

      Hi theBIbutler

       

      Im really struggling with this particular issue.  Pulling my hair out trying to get this right :)

       

      I know you did this a while ago but is it possible for you to share that .pbix with me?

       

       

      • 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