Forum Discussion
engingee
Helper I
4 years agocolour rule not apply
Hi Everyone, I set up this colour rule, but could not apply it, why is that please??? Thanks!!!
- 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.
VijayP
Community Champion
4 years agoThis 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!