Conditional formatting matrix columns

[Ciuciek]

Hi,

I've created P&L matrix (random data) showing in columns Actuals, Forecasts and Actuals vs Forecasts. I would like to apply conditional formating only to columns Actuals vs Forecasts and still have possibility to change versions by slicer as it is on the screenshot. Is there any solution for that? I've tried to create a measure but then the measure column is showing after ACT column and after RF3 column. I've also tried to change database layout but couldn't find any solution.

Thanks a lot!

[amitchandak · Accepted solution]

@Ciuciek , In matrix conditional formatting, can only happen for Values. Not for Row or column (pivot) 

For value formatting you can create a measure if needed and use that in conditional formatting using field value option

example

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

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

[Ciuciek]

Thanks, it is working. I recommend everybody watch @amitchandak youtube video: https://youtu.be/RqBb5eBf_I4