Conditional Coloring of data / variable progress bar goal

wegener · April 19, 2017, 9:12am

Hello,

we just started to use metabase dashboards for production monitoring. The first comment was whether data in tables, progress bars and numbers can be dynamically colored to emphasize some values.

It would be great if I could assign columns of a query to the background and font color of a number or progress visualization and data cells in table visualization respectively.

Whether it is useful to have a list of colors like red/blue/green/… or to use (hex-)rgb-values might be discussed or just defined by the developers.

Furthermore it would be helpful for progress visualization to assign the goal value to a query-column. E.g. for the total number of packets that needs to be shipped today.

Many thanks in advance. Keep on the good work.

Best Regards,
Axel Wegener

maz · April 19, 2017, 5:05pm

I think this issue on github is tracking this feature request: https://github.com/metabase/metabase/issues/4477

wegener · April 20, 2017, 1:49pm

Hello,
thanks for the pointer. My main concern is more related to dynamic colors defined by the data source, especially for tables and numbers.

It goes into this direction:

github.com/metabase/metabase

Color table based on cell value - Feature request

opened 09:36AM - 11 Jan 17 UTC

closed 09:34PM - 05 Jun 18 UTC

jsve

Visualization/Chart Settings

It would be great to be able to somehow color the cells / rows of a table based …on the values in the cell / row. Coloring of cells would be great for example to illustrate customer retention, like in the appended file. Coloring of rows, based on the value of one or more of the cells would be great to draw special attention to some of the rows, might this be best / worst performer in a set of coworkers / products. Cell coloring should probably be a gradient between two values, or max / min in the set. Row colors could probably use the same gradient, or just a color if above / below a certain value. This functionality is similar to conditional formatting in excel. ![table1b](https://cloud.githubusercontent.com/assets/9053945/21842876/ee7c9402-d7e8-11e6-91a5-26c698eb78fe.png) ⬇️ **Please click the 👍 reaction instead of leaving a `+1` or 👍 comment**

github.com/metabase/metabase

Custom background colors for cards; change color based on values in card

opened 09:27AM - 11 Aug 16 UTC

TheElk205

Priority:P1 Type:New Feature Visualization/Chart Settings Visualization/Scalars

It would be a nice feature if cards in dashboards could be colorized. Maybe even… according to their values? For example if I have a card which displays the number of occurred errors, It could have a green background for 0 Errors, yellow background for 0 to 5 errors and a red background for more than 5 errors. ⬇️ Please click the 👍 reaction instead of leaving a `+1` or 👍 comment

drewbie · April 15, 2025, 6:40pm

Has this feature been added? I am coming across a similar issue where I want to set up a progress bar and have conditional formatting on it. The gauge chart is nice but it takes up a lot of space and is not super easy to visually compare values across gauges.