Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
BI_Dev
Creator II
Creator II

RGB Based on the value.

Hi,

I have data a below.

StateMetroCityAddress
ColoradoDenverDenver123 ABC street
ColoradoLittletonGolden134 ABC street
ColoradoDenverLittle100 ABC street
ColoradoLittletonGolden111 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

 

Labels (1)
1 Solution

Accepted Solutions
StarinieriG
Partner - Specialist
Partner - Specialist

Hi,

try to see file attached

View solution in original post

3 Replies
mfarsln
Creator II
Creator II

Hi,

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

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

 

StarinieriG
Partner - Specialist
Partner - Specialist

Hi,

try to see file attached

BI_Dev
Creator II
Creator II
Author

Works like a charm.TY much.