Conditional Formatting

[Anonymous]

Hi,

I have a matrix table full of 5 columns that have dates in them and in the first column i have full names. How can i conditonal format the dates to highlight dates that:

a) Have been processed in the past from today's date - dynamic(processed has 3 values - processed, pending, delayed) that have a value of processed

b) dates that are pending to be processed in the future (from today's date)

c) dates in the past that have not been processed from today's date and before (most important)

[amitchandak]

@Anonymous , if You are using any column in row or column in the matrix then you can not do conditional formatting as of now.

If they are part of values, you can use color measure . and use in conditional formatting using field value option

examples 

Color sales = if(AVERAGE(Sales[Sales Amount])<170,"green","red")
Color Year = if(FIRSTNONBLANK('Table'[Year],2014) <=2016,"lightgreen",if(FIRSTNONBLANK('Table'[Year],2014)>2018,"red","yellow"))

Color = if(FIRSTNONBLANK('Table'[Year],2014) <=2016 && AVERAGE(Sales[Sales Amount])<170
,"lightgreen",if(FIRSTNONBLANK('Table'[Year],2014)>2018,"red","yellow"))
Color sales = if([Sales Today] -[sales yesterday]>0,"green","red")

color =
switch ( true(),
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity1" && sum('Table'[Value]) >500,"lightgreen",
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity2" && sum('Table'[Value]) >1000,"lightgreen",
// Add more conditions
"red"
)

refer if needed

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4