Hi all, I’m on Grafana 9.2 with a simple Pie Chart. sum by (ProductVersionYear, ProductUpdateLevel)(sql_server_version{job="$job", ProductVersionYear=~"$sqlversion", exported_instance=~"$dbinstance"}) I would like to know if…is it possible sort legend by label? From PromQL naturally is not possi…

You might have to go with regex-ing your label so that, if all labels have CU, you just get the numeric value of the labels such as 201710 201914 Because what you have is string, 2019 C14 comes before 2019 C8 [image]

Hello What have you tried as far as regex with PromQL?

No, honestly it’s more logical that it’s sorted by value… I’ve thought about it. I put a table in another panel with the sorting to my liking. However I tried to see your indication, but I found it difficult to use the regexp … and to the logic of how to apply it.

[image] alencappelletti: it difficult to use the regexp … I used to feel the same way, time to learn it. It is a lifesaver. Use regex101.com /[^a-z0-9+]+/gm

I will try in WE… Thanks @yosiasz

[image] alencappelletti: I will try in WE… WE? Check this out [image] regex101: build, test, and debug regex Regular expression tester with syntax highlighting, explanation, cheat sheet for PHP/PCRE, Python, GO, JavaScript, Java, C#/.NET, Rust.

Hi @yosiasz , thanks for your suggestion… regex101 it’s a great site, I use it too… but maybe I explained myself badly… also because I reply to these posts late at night and many times I’m tired, by the way, my problem wasn’t so much finding a pattern for the match but it was how I then had to inser…

Hello, have you found the solution to sort the legend not by the value default? or even grouped the pie portion?

What problem are you trying to solve in your case?

[1e] I have this pie chart and still wondering to group it into blue at the right side and red on the left side with that shown portion. Only for a beauty viz, sir. As far as I know, the pie portion order is Descending Clock wise, but i am not so sure.

Pie Chart sort legend label (not by value)

Grafana Pie Chart Panel

tantranncs June 13, 2023, 9:51am 16

HI yosiasz,
I’m having the same problem as the author, and I want to sort the legend in order of Critical, Hight, Medium and Low, can you guide me in detail?
Thanks

Topic		Replies	Views
Unable to sort the Legend in a dashboard query Dashboards	5	900	October 4, 2024
Pie Chart Panel Configuration	0	629	December 9, 2019
How to sort the legend? Dashboards	4	4763	May 27, 2025
Grafana sort by labels with prometheus datasource Dashboards	0	869	October 9, 2023
Error ordering pie chart query Time Series Panel postgres	2	607	January 13, 2022

Pie Chart sort legend label (not by value)

Related topics