Color coded by values

[louise119]

I have a table that is color coded by values of data like an image.
Is it possible to narrow down the data to be displayed in the table, such as only yellow, orange, or red columns in this data2 column?

 

[salonicdk28]

Hi, Yes you can do that by writing an expression as per you want in background color expression which is under expression as shown below-

[Or]

You can't filter a table based on its internal color settings, as far as I know.

Depending on how the color was set, you may be able to use the same formula or a similar one to either limit the dimension values, or modify the measures, e.g. if the definition of red is data1 = 100000453, you could use e.g. Sum({< data1 = {100000453} >} Field) as your measure, and then hide zero/null rows.

Another alternative might be to have these colors loaded as a field, and then filter based on that field, e.g.

Load data1, data2, if(data1=SomeValue,'Red','Green') as Color From SomeTable;