Forum Discussion

Unicorn_Tech's avatar
Unicorn_Tech
Resolver I
5 years ago
Solved

Conditional Formatting based on time

Apologies if this is a duplicate post. I would like to set up conditional formatting, comparing one value in a column to another value in a column (for the same row.)  I want to know if Monthly Av...
Need Help
  • negi007's avatar
    negi007
    5 years ago

    Unicorn_Tech  Can you please try doing it below if helps you.

     

    Change the time value to below

     

    then create one measure like 

    Check = if (SUM(Page[Yearly Average])>SUM(Page[Monthly Average]),1,0)
     
    then set the rules like below for both monthly average and Yearly Average

    below is the ouput

     

negi007's avatar
negi007
Community Champion
5 years ago

Unicorn_Tech  Can you please try doing it below if helps you.

 

Change the time value to below

 

then create one measure like 

Check = if (SUM(Page[Yearly Average])>SUM(Page[Monthly Average]),1,0)
 
then set the rules like below for both monthly average and Yearly Average

below is the ouput

 

  • Unicorn_Tech's avatar
    Unicorn_Tech
    Resolver I
    5 years ago

    Thank you so much!