This is a simple problem but I cant seem to get it to work correctly. I have a line graph with total cost on the y axis broken out by month per year on the x axis. All I want is to have the max total cost display as a red data point the the others black- Im using SQL Server 2008 R2- cant seem to the expression correct Thanks kam

Not sure try this, IIF( MAX(Fields!YourMeasure.Value)= Fields!YourMeasure.Value,"RED","BLACK")Gaurav Gupta http://sqlservermsbiblog.blogspot.com/

Thanks for helping but it didn't work- this shouldnt be a difficult fix but cant get it to work :-(

Hi Kam, For example, if the field name of total cost is TotalCost in the dataset, and the chart name is Chart1, please refer to the following steps to set color of the max total cost point to red. 1. Suppose we have already added the TotalCost field to the Values list and add date field to Category Groups. Please right click TotalCost in the in the Values list and select Series Properties… 2. In the Series Properties window, select Markers in the left list. 3. Select a marker type in the dropdown list. 4. Click the fx button after Marker color then specify the expression like =IIf(Sum(Fields!TotalCost.Value)=Max(Sum(Fields! TotalCost.Value),"Chart1"),"Red","Black") Please be aware to change the field name and chart name in the expression. Thanks, Tony ChainPlease remember to mark the replies as answers if they help and unmark them if they provide no help