# Sort bar gauge by value with multiple series

**URL:** <https://community.grafana.com/t/sort-bar-gauge-by-value-with-multiple-series/161222>\
**Category:** Dashboards\
**Created:** [January 22, 2026, 3:24am UTC](https://community.grafana.com/t/sort-bar-gauge-by-value-with-multiple-series/161222 "2026-01-22T03:24:45Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![llamafilm](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/llamafilm/32/36888_2.png) [@llamafilm](https://community.grafana.com/u/llamafilm)\
**Post date:** [January 22, 2026, 3:24am UTC](https://community.grafana.com/t/sort-bar-gauge-by-value-with-multiple-series/161222/1 "2026-01-22T03:24:45Z")

</div>

I have a bar gauge based on Prometheus query `probe_ssl_earliest_cert_expiry * 1000` that looks like this. How can I sort it by value? The “sort by” transformation doesn’t work because each bar is a different series. I tried “series to rows” followed by “sort by” but that mangles the data.

 ![image](https://us1.discourse-cdn.com/grafana/original/3X/2/a/2ab724632bc4341b43538ed854a39617174070dd.png)  
 ![image](https://us1.discourse-cdn.com/grafana/original/3X/c/3/c3559d269094904a7dfd283d81813b9997b48947.png)

---

<div class="post-metadata">

**Author:** ![llamafilm](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/llamafilm/32/36888_2.png) [@llamafilm](https://community.grafana.com/u/llamafilm)\
**Post date:** [January 22, 2026, 4:23am UTC](https://community.grafana.com/t/sort-bar-gauge-by-value-with-multiple-series/161222/2 "2026-01-22T04:23:31Z")

</div>

I figured it out! Couldn’t get it to work with a bar gauge so I switched to table instead, with an instant table query. Instead of setting the unit to “time from now”, I had to set that as an override just on the Value column, and change its cell type to Gauge. I used “organize by fields” to remove the extra columns,