Line graph generated based on given parameter SSRS

722 views Asked by At

I have a line graph for the query below.

Select Date
      ,Time
      ,MaxValue
      ,MinValue
from MyTabl
where product = @Product
  and (Date between @FromDate and @ToDate)

For Line Graph, add one parameter Interval(Values - 2, 4 ,8, 12, 24).

I want to show line graph data points differently based on the parameters selection.

Now, it return 50 rows where in line graph I mapped x-axis for date,time, y-axis for MaxValue. It remain shows the same graph for all interval

How can I include Interval Values in linegraph, so that graph displays based on interval values?

LineGraph

1

There are 1 answers

2
Aldrin On BEST ANSWER

Did you already tried going to Horizontal Axis Property of your chart? There's an interval property in there under Axis Options tab. Just click the expression icon then put your Parameter in the expression like this Parameters!ParameterName.Value