How to better control the curve in smooth line graph of SSRS ?

Question

I have a smooth line graph. I am trying to understand if I can apply some settings on the curve properties so that the curve does appear as if it had negative Y Axis values.
In the attached picture, I have highlighted a portion of the curve where it appears as though the Y Axis value has gone negative and became positive as we move along the X Axis. Is there a way to configure settings such the I provide the minimum limits for the curve.

Answer 1

Hi @Rao, Avinash
I did a local test in Report Builder 3.0 , and it had negative Y Axis values by default.

This is my default vertical axis setting.

Can you clarify what version of SSRS you are running, please? If you are on SSRS 2008, there is an option for the axis for specifying where the axis crosses at.

Here is the reference thread,maybe you can take a reference:https://social.msdn.microsoft.com/Forums/sqlserver/en-US/d7b00bf5-7295-48c0-8348-f0fa1c62f383/column-chart-not-displaying-negative-y-axis-in-ssrs
Hope this can help you.

Best Regards,
Isabella

---

If the answer is the right solution, please click "Accept Answer" and upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @Rao, Avinash

I think the default setting for this smooth curve is a bezier curve, the curve is tangent to all points.There is no way you can change it. I agree your idea of using a line graph.

Best Regards,
Isabella