Color Bar Chart based on Groups

  • What Grafana version and what operating system are you using?
    Grafana v10.3.1

  • What are you trying to achieve?
    I try to have all bars within a group colored by the same color.

  • How are you trying to achieve it?
    I have tried a singe pgsql query and also merged multiple pgsql queries in table mode.
    I set “Color by field” to the grouped field → didn’t work
    I tried overrides based on clicking on the legend and selecting a color → didn’t work
    I tried multiple color schemes → didn’t work

  • What happened?
    All charts of all groups have the same color. I can change all from green to blue or whatever but I cannot use the color to distinct between different groups and the x-legends to distinct within those groups.
    When using overrides I just see “field_value (not found)” in the override

  • What did you expect to happen?
    I expected that all bars of a each group (same value in the specific field) selected in “color by field” to have the same color.

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

  • Did you follow any online instructions? If so, what is the URL?
    I checked multiple posts here in the forum, for example the suggestion to use multiple queries but was not successful with that.