CODEWITHSUNDEEP
reporting-servicesssrs-2012
Kelly
Kelly

Reputation: 985

How to set custom horizontal axis interval in SSRS chart? It always shows every other label

I have an SSRS report, confused on which version- somewhere between 2008-2014. I'm developing it in VS 2013. I have a chart with an x axis showing category groups, which is a date field displayed using an expression. I do not want it to show every date when there are a large amount, so I tried writing an expression for the Interval field like below to set the interval based on how many rows there are, but it always shows every other label. I will even just set the interval to simply 4 or 6 or 10 or whatever and it always shows every other label, as if the interval is 2. I attached a screen shot to show where I'm changing it. If I change my parameters and run the chart for different data, it will show the interval as 1 sometimes. Maybe there's another place where the interval can be set?

enter image description here

3 different interval expressions I've tried

 =Ceiling(CountRows("GetAllStatusMeasureData") / 30)

  4

 =4

 "4"

Upvotes: 0

Views: 9229

Answers (1)

Kelly
Kelly

Reputation: 985

Turns out there is a separate interval for the labels on the axis- I incorrectly assumed it was all the same. I looked at the Properties window for the Chart Axis and it showed a LabelIntervalOffset and that was the one I needed to change, not the Interval in the section called Interval. Screen shot below:

enter image description here

Upvotes: 3

Related Questions