What Grafana version and what operating system are you using? 9.3.6 running on MacOS, datasource is using the BigQuery datasource from Grafana Labs version 1.2.4. What are you trying to achieve? Setup a variable with a value and a text field so that the text field is displayed but in the dash…

I just get the string value - the problem is it’s not correctly mapping the __text and __value columns. However, if I put them in reverse order (__value and then __text) it works which is a fix … of a kind … probably still a bug that needs looking at though! So in summary the SQL; SELECT DISTINCT…

value and text for variables not working as expected

Grafana Dashboards

andypellew May 1, 2023, 2:45pm 3

It’s an integer - does it need to be text?

Support for variables __text and __value - Redshift plugin

Topic		Replies	Views
Variable query options: text + value in SQL Dashboards dashboard-variables	3	6127	November 28, 2022
Support for variables __text and __value - Redshift plugin Developers & API	7	411	May 8, 2024
Variable value being interpreted as a column name Dashboards	5	1303	September 22, 2023
Variable with Text and Value bug (I assumed) Dashboards	8	1306	January 27, 2023
__value variables assigned incorrectly in state timeline with multiple queries PostgreSQL data-links	0	281	November 28, 2023

__value and __text for variables not working as expected

Related topics

value and text for variables not working as expected