Tuesday, February 19, 2013 10:27 PM
I'm having trouble with an expression. I'm trying to change the color of my lines in SSRS. I really just want to make the field RunningTotalThisYr orange, RunningTotalLastYr black, and Goal red. (As a side note, I'm just using "Goal" to put a threshold line to see how close we are to meeting our goal). Here's what I've tried:
=Switch(Fields!RunningTotalThisYr.Value > 0, "Orange", Fields!RunningTotalLastYr.Value > 0, "Black", Fields!Goal.Value > 0, "Red")
Here is the dataset:
Here is the result:
Any help is appreciated :-)
Wednesday, February 20, 2013 3:54 AMWhere have you put the expression? I dont think you even need an expression. Can you just highlight each line series and change the colour in the properties window?
- Marked As Answer by towardabettercountry Wednesday, February 20, 2013 2:19 PM
Wednesday, February 20, 2013 4:21 AM
Correct no need of expression for this because all are different measures select on the line and go to properties window and change the property "color" to required color.
Please don't forget to Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful. It will helpful to other users.