Support for per-bar colors in bar charts

Hello,

I would like to assign a different color to each bar in a horizontal bar chart, but it seems the color parameter is
only available at the top-level (component) level and not at the row level.

Here is what I'm trying to achieve:

  SELECT
      'chart'                          AS component,
      'Comptes expirant prochainement' AS title,
      'bar'                            AS type,
      TRUE                             AS horizontal,
      TRUE                             AS labels;

  SELECT '30 jours' AS label,
      100           AS value,
      'green'       AS color;

  SELECT '60 jours' AS label,
      200           AS value,
      'orange'      AS color;

  SELECT '90 jours' AS label,
      300           AS value,
      'red'         AS color;

I would expect each bar to have its own color (green, orange, red), but currently only the top-level color parameter
is applied uniformly to all bars.

Is there a way to set a different color per row in a single-series bar chart? If not, would it be possible to add
color as a row-level parameter?

Thank you!

Indeed, I understand this is a bit counterintuitive, but colors need to be declared at the top level.
Colors are attributed per-series, so you need to give a single x value to all bars, with different series:

  SELECT
      'chart' AS component,
      'Comptes expirant prochainement' AS title,
      'bar' AS type,
      TRUE  AS horizontal,
      TRUE  AS labels,
      json('["green", "orange", "red"]') AS color;

  SELECT '30 jours' AS series, 'Comptes' as label,
      100 AS value;

  SELECT '60 jours' AS series, 'Comptes' as label,
      200 AS value;

  SELECT '90 jours' AS series, 'Comptes' as label,
      300 AS value;

Thanks for the explanation , that makes sense now.

Thanks for the clarification and the example!

with #1375 #1376 and #1377 , rows now serialize as objects and are able to configure the colours of reference lines & areas. this concept could be reused for this

@81reap

@81reap the new general 'color' row level property could be used for normal datapoints too, finally implementing this feature request

raised #1404

Navigation Menu

Repository navigation

Support for per-bar colors in bar charts #1228

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Support for per-bar colors in bar charts #1228

Description

Activity

lovasoa commented on Mar 5, 2026

wissyfaty commented on Mar 15, 2026

81reap commented on Aug 13, 2026

lovasoa commented on Aug 23, 2026

81reap commented on Aug 25, 2026

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions