Rename column taking data from a query in a variable

[it_ara]

Hi.
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?

[yosiasz]

You can extract either one of them using

$variable:value
$variable:text

[it_ara]

Doesn’t works.

[yosiasz]

oops, maybe this?

${variable:value}
${variable:text}

[it_ara]

@yosiasz

${variable:text}

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