DAX formula to get different Index colours

[Anonymous]

Hi Community,

thank you in advance!

I was looking for some days to get a DAX formula to provide me the following:

Quality AIBI: if Actual month is greater than AOP Month, the Index column (102) needs to be green.

Quality - #quejas de calidad: if Actual month is greater than AOP Month, the Index column (275) needs to be red.

Quality - #quejas de m extraña: if Actual month is greater than AOP Month, the Index column (250) needs to be red.

Below you may find the table and the configuration of our rows and columns.

Could you please help me to figure out?

thank you all!

Guido

[amitchandak · Accepted solution]

@Anonymous , Create a color measure like given below and use that with "Field" option in Conditional formatting

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"
)

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values