colour rule not apply

[engingee]

Hi Everyone, I set up this colour rule, but could not apply it, why is that please??? Thanks!!!

[v-yalanwu-msft · Accepted solution]

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.

[engingee]

I got it eventually, thanks very much for your help! @v-yalanwu-msft 

[VijayP]

@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]

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