Conditional Formatting Rules Work in the Opposite Way as Specified

[djs1984]

Hi,

Whilst working on an analysis services report I came across an issue with the conditional formatting functionality. After creating a new measure which produces a variance column I wanted to have negative percentage variances be highlighted in red. The rule required to achieve this works, but in the complete opposite way (see image)

I managed to achieve the result by reversing the colour definitions, but basically it seemed to be doing the oppsite as was specified in the rule. The result of the rule in the image is that all negative percentage values are ow highlighted in red, and all neutral or positive values are black.

[v-qiuyu-msft]

Hi @djs1984, 

Did you connect to SSAS in a live connection or import mode? 

Please drag the measure Tonnage Variance to the same table visual then compare the conditional formatting color with measure values. Also please modify the first condition as below then test again: 

Best Regards,
Qiuyun Yu

[Sarah0112358]

I had a similar "reversing" issue when trying to apply red X icons to "0" values and green tick icons to "1" values.  It was reversing everything, making 0 green and 1 red.  It turned out I had to change it from "Summarization by Count" to "Summarization by Sum" in the Advanced Controls menu, before it then it correctly followed my instructions. (Slightly different than your set-up, but posting in case it helps.) 

 

Regards,

Sarah