SSRS charts do not show labels qwith zero (not null) values even when interval 1 is selected

Question

I have charts where the script produces all weeks in the year and I report the activity. The X axis labels where the activity is zero and not null are not appearing.

Please can someone help  - I have selected interval 1 on the chart x axis. I have searched the net for help but found nothing.

Can this problem not be fixed?

Answer 1

Hi Juliet,

What is the data type of the field that placed in the Category group area of the chart? If the Weeks are numeric values, please open the “Horizontal Axis Properties” dialog box, set the “Axis type” to “Scalar (Numbers/Dates)”, and then set the “Interval type” to “Number” and “Interval” to 1.

If the Weeks are date values, please open the “Horizontal Axis Properties” dialog box, set the “Axis type” to “Scalar (Numbers/Dates)”, and then set the “Interval type” to “Weeks” and “Interval” to 1.

If the issue persists, please send me the files to sqltnsp AT Microsoft.com (Please replace AT with @) or upload the files to skydrive.live.com so that we can make further analysis and help you out.

Regards,

---

Mike Yin
TechNet Community Support