Forum Discussion

Ciuciek's avatar
Ciuciek
New Member
4 years ago
Solved

Conditional formatting matrix columns

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 h...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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

amitchandak's avatar
amitchandak
Super User
4 years ago

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