Forum Discussion
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....
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!
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.
