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!!!

 

 

Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    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.

4 Replies

  • VijayP's avatar
    VijayP
    Icon for Community Champion rankCommunity Champion
    4 years ago

    engingee 

    This is formula issue 
    IF (Selectedvalue()<4|| SelectedValue<50 || Selectedvalue() <2, you need to give color name not number without color name formula cannot understand which color to take!

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

      thanks VijayP may I know what is the correct way to write please, if the colour I want is red please? Thanks!

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Icon for Community Support rankCommunity Support
    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.