Expression to colour font

Question

I've used the following expression to change the colour of my font, its working to an extent apart from values that are zero, which are remaining black.

=Switch(
Fields!Colour.Value="Orange","#ff8812" ,Fields!Colour.Value="Blue","Blue" ,  Fields!Colour.Value="Green","Green" ,Fields!Colour.Value="Red" ,"Red" ,true,"No color")

You could pick any color and then write an expression to control the `Visibility` to hide the 0's. — StevenWhite, Apr 10 '17 at 15:57

score 3 · Answer 1 · answered Apr 10 '17 at 12:23

3

"No Color" isn't a valid value for fonts.

answered Apr 10 '17 at 12:23

BishNaboB

1,047
1
12
25

score 0 · Answer 2 · answered Apr 26 '17 at 14:59

0

Just add your expression as the color

answered Apr 26 '17 at 14:59

Rickey Alterman

11
6

Expression to colour font

2 Answers2