Chart Axis Labels in SSRS – Expressions Do Not Work

I was enhancing a report in the DBA Repository project today when I decided to make a bar chart have slick formatting on the X-axis labels.  I wanted some labels in red font if the values were above a threshold.

So, opened the horizontal axis properties window, went to the label font tab and clicked the expression button for the color property.  I added a simple IIf expression to make some labels red and others black, previewed the report and bam, no change…

After being confused for a while I found that expressions don’t work on on the color property of axis labels even though the applet allows you to define them.

Oh well…

Leave a Reply

Your email address will not be published. Required fields are marked *