Forum Discussion

dkinchit's avatar
dkinchit
New Member
7 years ago

Sorting Legend in a Line Chart

Problem: I cannot sort the legends based on the chosen category's sales proportion, PBI does it based on alphabetical order. Strange given you would have expected this to occur by default like excel....
Need Help
alena2k's avatar
alena2k
Resolver IV
7 years ago

If you are looking for the last reported month ranking, you could add calculated column which would use data using filter of last month from today's month. 
It should work for your categorical filters as well. It will not work for date filters if you need them.

dkinchit's avatar
dkinchit
New Member
7 years ago

alena2k - Tks! As you can guess I am still a newbie so would appreciate if you could post a sample formula of sorts of how I would define that new column?

 

Appreciate your time!

  • alena2k's avatar
    alena2k
    Resolver IV
    7 years ago

    I hope that something like this will help you:

     

    Last Reported Rank =

              RANKX(Categories,
                              CALCULATE(SUM('Sales'[Sales]), 'Sales'[Date] > EOMONTH(NOW(), -1),'Sales'[Date]<= EOMONTH(NOW(), 0))
             ,,DESC)

    I assume that yiy have Caregories table where you can setup sorting by this column.

     

    • dkinchit's avatar
      dkinchit
      New Member
      7 years ago

      Thanks alena2k...sorry I just saw this so will try this now. Will update soon.

      • momedina's avatar
        momedina
        Frequent Visitor
        7 years ago

        Any luck with the solution provided? I have been trying to solve (almost ) the exact same problem for last couple of weeks and can't seem to hit it right. I try sorting by column but it gaveme an error