Forum Discussion

engingee's avatar
engingee
Icon for Helper I rankHelper I
4 years ago
Solved

colour rule not apply

Hi Everyone, I set up this colour rule, but could not apply it, why is that please??? Thanks!!!    
  • v-yalanwu-msft's avatar
    4 years ago

    Hi, engingee ;

    You could try two methods about conditional format.

    1.create a measure.

    Measure = IF(SELECTEDVALUE(financials[Year])>2013||SUM(financials[ Sales])>6000000,"red","white")

    Then select field value ->measure.

    The final output is shown below:

    2.Or create a measure.

    Measure 2 = IF(SELECTEDVALUE(financials[Year])>2013||SUM(financials[ Sales])>6000000,1)

    then select rules ->measure 2

    The final output is shown below:

     


    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.