RGB Based on the value.

[BI_Dev]

Hi,

I have data a below.

State	Metro	City	Address
Colorado	Denver	Denver	123 ABC street
Colorado	Littleton	Golden	134 ABC street
Colorado	Denver	Little	100 ABC street
Colorado	Littleton	Golden	111 ABC street

Can I set the background color of Address column to change based on the selection.

Ex:If I pick Littleton, I want 134 ABC and 111 ABC street bkgrd to be green and the rest of the address go blue.

Thank you

[mfarsln]

Hi,

You can try something like below expression for Address column's background color expression.

if(
GetFieldSelections(Metro,',') = 'Littleton',green(), blue()
)

[StarinieriG · Accepted solution]

Hi,

try to see file attached

[BI_Dev]

Works like a charm.TY much.