In XY-chart the entries of value mapping do not appear in the legend

  • What Grafana version and what operating system are you using?
    Windows 11, Grafana v9.5.14

  • What are you trying to achieve?
    In Grafana XY_chart i have a tabel with three columns:
    The x_axis and y_axis values are sensor inputs
    The color_axis_values is an integer between 1 and 10.

In the XY chart i want the color_axis_values to decide the color of the point and the color should show up in the legend.

I then use configure from query result to change the color:

  • What happened?
    It correctly changes the color in the plot, however the legend only have one color.

  • What did you expect to happen?
    I hoped that the value mapping would override the legend so that each value mapping was an entry in the legend. The Text in the legend would then be the value mapping.