SSRS Grouped column Chart not showing all labels

I am creating a grouped column chart in SSRS. The user enters a data range, and the data is grouped by asset, then by date, starting on mondays. The chart displays correctly but not all the labels of the sub group weeks are shown. I cant figure out what rhyme or reason it uses to display this.

How can i force SSRS to display all labels? please see attached image showing hte current chart, and the data /chart setup. notice it doesnt even show the same series label for each group...
chart1.PNG
Chart2.PNG
data-result.PNG
LVL 1
mikegrad7Asked:
Who is Participating?
 
ProjectChampionConnect With a Mentor Commented:
Have you tried setting the interval value to 1 under the "Chart Axis" properties?
0
 
mikegrad7Author Commented:
that did it. I didnt think it was an option to type into the field - the only thing int he dropdown was "Auto".

Thanks for the help!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.