Color Code Text Values in Matrix

[jeamps01]

Is there a way that I can color code the values based on an "If Text contains" logic. Values in Matrix are in a text format.

For example, FLLFP would show up green in both columns and MIALL yellow in both columns, etc.

[v-luwang-msft · Accepted solution]

Hi @jeamps01 ,

See the below sample:

base data:

Color measure:

COLOR = VAR TEST1=LEFT(MAX('Table'[value]),4)  RETURN IF(TEST1="FLLF","Green",IF(TEST1="MALL","Yellow",BLANK()))

Then:

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[speedramps]

mycolour =
STRING(True(),
CONTAINSSTRING(tablename.fieldname, "FLLFP"), "green",
CONTAINSSTRING(tablename.fieldname, "MIALL"), "yellow",
BLANK()
)

Then in the matrix right click on Values > Conditional formating >  Backgground colour >
Format style = Field value

Based on = mycolour 

[jeamps01]

Thank you Speedramps. This doesn't work for some reason. STRING isn't a valid formula. I have SWITCH or SELECTEDMEASURESTRING as possible options.

Also my field name "Name + RGI" does not show up as a possible selection option for either of these formulas. I only see that Measures show up as possible options.

[speedramps]

Sorry, for the autotext correction mistake.

Yes SWITCH should have been STRING !

😀