# Postgres Bargauge not working

**URL:** <https://community.grafana.com/t/postgres-bargauge-not-working/59060>\
**Category:** PostgreSQL\
**Tags:** postgres, bar-gauge\
**Created:** [January 14, 2022, 4:50pm UTC](https://community.grafana.com/t/postgres-bargauge-not-working/59060 "2022-01-14T16:50:04Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![robert2007](https://avatars.discourse-cdn.com/v4/letter/r/bc79bd/32.png) [@robert2007](https://community.grafana.com/u/robert2007)\
**Post date:** [January 14, 2022, 4:50pm UTC](https://community.grafana.com/t/postgres-bargauge-not-working/59060/1 "2022-01-14T16:50:04Z")

</div>

- What Grafana version and what operating system are you using?  
I am using Grafana 8.3.0
- **What** are you trying to achieve?  
I am trying to show multiple values in a bar-gauge.
- **How** are you trying to achieve it?  
I used this query:  
SELECT  
NOW() AS time,  
(ROW\_NUMBER() over(order by value desc)) || '. ’ || name as metric,  
value  
FROM table  
ORDER by value desc  
LIMIT 10
- What happened?  
They are ordered by metric name. Starts with 1. {name}, 10. {name} then goes from 2-9
- What did you **expect** to happen?  
The result to be ordered by value and not by the name. It worked like this before the update from Grafana 7 to 8.  
Also if I put ${\_\_series.name} in the Display name field it just shows Series (A) instead of 1. {name} for example