conditional formatting matrix

[LauraBueno]

Hi everyone,

I am trying to apply conditional formatting to a matrix depending on the values displayed (more negative values will be red and move towards green as values get more positive). However, the conditional formatting apply across all columns and I will like to have this comparison per column displayed in the matrix. Is there a way to do this?

This is the table I have. I would like to show the colour formatting (red - green) for the variable delta vs Reference for each of the samples. However when I apply the conditional formatting the colouring applies comparing all samples (since the variable is the same). Is there a way to break it per column (sample as in table below)? 

thanks

Laura

[amitchandak · Accepted solution]

@LauraBueno , not sure I got it. But you can create a color measure on dimension values and measure values like this

Color Date = if(FIRSTNONBLANK(Table[date],TODAY()) <today(),"lightgreen","red")
if(FIRSTNONBLANK(Table[Value],"true") "true","green","red")


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

And this can be used in conditional formatting after selecting "Field". Once you use it one column , it will be there for all samples

refer:
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting