Forum Discussion

Kimia79's avatar
Kimia79
Frequent Visitor
4 years ago

Conditional formatting based on two other columns

Hi,

 

I need to write a formula for this table based on two other columns, one column has text format and the other has value.

e.g. If the pattern is Current and the value is 1 assign 1. If the pattern is online and the value is 1 assign 2. If the pattern is current and the value is 0 assign 0. else assign 3.

 

Can anyone help me?

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Kimia79 , You can a color meausre, You can use dimesion value with max() or min () or FIRSTNONBLANK or LASTNONBLANK and measures. Use that in measure 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"))

     

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

     

     

  • v-luwang-msft's avatar
    v-luwang-msft
    Community Support
    4 years ago

    Hi Kimia79 ，

    Like Sara.v ,subject1 ,currect and  online all is 1,output is 1+2=3?

    Could you pls show the output result you expected?

     

     

     

    Best Regards

    Lucien