Very basic drop down question

Hi

On my Grafana Dashboard, there is a drop down to select run ID from influxdb, whose query is

SHOW TAG VALUES FROM "requestsRaw" WITH KEY ="runId"

Its “Sort” is “disabled”, however the output list is in ascii order. Yet I want to make my latest Id show up first, so I change it to:

SHOW TAG VALUES FROM "requestsRaw" WITH KEY ="runId" ORDER BY time DESC

but the show up list is still in ascii order. How to get what I want please?

Configure value sort on the page, where you configure that dashboard variable (don’t sort in the query). There is config option for that usually.