How to display the actual reading alone the dot and conditional change the color of the dot/figure if it is over / below an alert figure

Hi,

You have to explain your problem clearly with as much details as possible including the version of the SQL you are using so that everyone here can understand. From the title of your post it looks like that you want to change the color of the data series marker (the dot in the picture above) in a SSRS chart.

If I have understood you correctly then here is how you can do it.

1. Select the data series properties. Select and right click on the line in the chart in design mode. Then click on "Series Properties" and go to the properties tab for "Markers". Under "Marker Color" drop down select the expression and set the expression as shown in the picture. Replace "Field!Qty.Value" with appropriate field and the criteria for the upper and lower bound you want with their respective color.

2. You can see in the snapshot below that the color of January Month has changed to Red since the qty value is less than 300 as set in the expression above.

---

--sIbu