How to sort the legend?

[ashketchup92]

• What Grafana version and what operating system are you using?
  11.0.0

• What are you trying to achieve?
  I´d like to sort my legend on custom behaviours e.g. ERROR, WARN, INFO instead of INFO,ERROR,WARN
  

  

• How are you trying to achieve it?
  I tried to use the Legend-Options but there is no sorting available.

Also i tried to use the transformation with the option sort, but this also didn´t gave me the solution

• What happened?

• What did you expect to happen?
  Sort the legends on custom behaviours or at least descending, ascendig and not randomly

[sowdenraymond]

Pie Chart sort legend label (not by value)

[image] I mapped the high, medium, low and critical statuses to numeric values and sorted on that numeric value select a.* from ( select 'A' metric ,84 value,'High' as status union select 'B',10,'Low' union select 'C',6,'Critical' union select 'D',40,'Medium' ) a join ( select 10 ste, 'High' as status union select 20 ste, 'Medium' as status union select 30 ste, 'Low' as status union select 40 ste, 'Critical' as status ) ste on a.status = ste.status order by ste.ste asc

[vijha1989]

Legends are sorted in descending order based on their value. In your example,
info - 42%
error - 39%
warn - 19%

That’s the reason legends are shown this way. if the value of these changes, the legend’s order will also change.