Barchart / X-Axis converted to unit

Grafana Bar Chart Panel
1
  • What Grafana version and what operating system are you using?

v8.5.3

  • What are you trying to achieve?

To have the x-axis in a bar-chart as normal strings. They are in the table as string but are displayed in the units in the chart

image
image452×636 13.5 KB

image
image928×460 10.6 KB

Now I of course would like to have the year displayed as normal string in the graph as well.

  • How are you trying to achieve it?

I have the years converted to string in my influx query.
I also played around with the “Convert field type” transformation. As soon as I do anything there, it shows the correct strings:

[Cannot upload another picture as I’m a new user…]

I can then save it but as soon as I exit to the dashboard view it has again the units attached.

  • What happened?

Grafana converts those year strings to a number and attaches the unit.

Anyone any idea how I can achieve this?

Thanks!
Oliver

2

It seems as it has this behaviour only when the string is only numeric. As soon as I attach a character, (e.g. “.”) it works fine.