Forum Discussion
colour rule not apply
- 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.
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.
I got it eventually, thanks very much for your help! v-yalanwu-msft