Rename column taking data from a query in a variable

I have a variable that shows the result of a query.
in the variable I show the values of a field, but others are used to show the data.
The query that I use is:


But I want that in the column of data, Grafana shows the “__text” data instead of “__value” data.
that is to say, I need that instead of 41, 42, 43, 51,52 (value __value in the query of the variable) etc… show “Meteo MS1, Meteo Ms2, RSU 1, etc…” (value __text in the variable query)

It is possible to do that?

You can extract either one of them using


Doesn’t works.


oops, maybe this?


Works better, but shows all the variables that are selected.

1 Like