First Value on Bar Chart Panel is missing (MySQL Query)

[michaeluray]

I read out some data via a MySQL query, but it doesn’t show me the first value on the Bar Chart Panel, even it is shown in the data table.
It shows the second value as first and the first is not shown anywhre, the data is missing as well.

The panel was just created and only the MySQL query got added, no transformations or other settings changed.

If I change the visualization to Timeseries, then the datapoint is shown there, but not in the Bar Chart view.

Any ideas?
Is that a bug?

• Grafana v12.2.1 (1276aa9aac) on windows.

[ebabeshko]

It is not missing - it is used as a description of your bars. Notice 65.3 under first set of bars, 128 under second set etc.

[ebabeshko]

Try explicitly setting X Axis:

[expoenergy]

Set x-axis to time in bar chart?

[michaeluray]

Strange, that the value column had no name caused the issue.

Thanks for your help guys, now it is shown correctly.

I actually removed that to get rid of the value prefix which shows up there: