Forum Discussion

shainis's avatar
shainis
Icon for Helper I rankHelper I
5 years ago
Solved

Duplicate conditional formatting to other tables

Hi,   I have this table:   with the following conditional formatting (the same for each on the columns):       Is there a way to duplicate this formatting to other tables? I have ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    shainis , You can create a color measure and then use that is 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")

     


    Refer my video for steps

    https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=14

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

shainis , You can create a color measure and then use that is 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")

 


Refer my video for steps

https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=14