如何根据thresh保持值改变字体的颜色 [英] How to change color of the font based on the thresh hold value

问题描述

我有一个要求，如果阈值大于6％，文本颜色应该显示为红色，5-6％之间应该更改为黄色。我尝试这个表达式在文本框字体颜色属性的第一个需求iif（fields！My_column.value> 6，红色，黑色），但没有工作。我会感谢任何提示，我的两个问题。感谢

I have a requirement like if the the threshhold value is greater than 6% the text color should appear as red and between 5-6% it should change to yellow. I tried this expression in the text box font color property for the first requirement iif(fields!My_column.value>6, "red","Black") but did not work. I would appreciate any tips for both of my problems. Thanks

推荐答案

没有理由这不应该工作。

No reason this shouldn't be working.

您可以为文本框设置颜色属性，但应该没问题。

You can set the Color property for a Text Box and it should be fine.

=Switch(Fields!My_column.Value > 6, "Red"
    , Fields!My_column.Value < 5, "Black"
    , true , "Yellow")

赠送：

您的基础数据如何显示？是6％ 6 还是实际上是 0.06 ？

How does your underlying data look? Is 6% "6" or is it actually "0.06"?

这篇关于如何根据thresh保持值改变字体的颜色的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！