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


i have ssrs report, confused on version- somewhere between 2008-2014. i'm developing in vs 2013. have chart x axis showing category groups, date field displayed using expression. not want show every date when there large amount, tried writing expression interval field below set interval based on how many rows there are, shows every other label. set interval 4 or 6 or 10 or whatever , shows every other label, if interval 2. attached screen shot show i'm changing it. if change parameters , run chart different data, show interval 1 sometimes. maybe there's place interval can set?

enter image description here

3 different interval expressions i've tried

 =ceiling(countrows("getallstatusmeasuredata") / 30)    4   =4   "4" 

turns out there separate interval labels on axis- incorrectly assumed same. looked @ properties window chart axis , showed labelintervaloffset , 1 needed change, not interval in section called interval. screen shot below:

enter image description here


Comments

Popular posts from this blog

cookies - Yii2 Advanced - Share session between frontend and mainsite (duplicate of frontend for www) -

angular - password and confirm password field validation angular2 reactive forms -

php - Permission denied. Laravel linux server -