reporting services - All X-axis labels not showing up for null values of Y-axis in SSRS -

reporting services - All X-axis labels not showing up for null values of Y-axis in SSRS -

my sql server query has output: period_code periodname nrri depleted rvcr arri 201401 jan 90 100 101 98 201402 feb 101 100 110 101 201403 mar 97 100 92 97 201404 apr 88 100 92 null 201405 may 88 100 102 null 201406 jun null 100 null null 201407 jul null 100 null null 201408 aug null 100 null null 201409 sep null 100 null null 201410 oct null 100 null null 201411 nov null 100 null null

the study line chart having x-axis labels periodname i.e. jan, feb, etc. y-axis has numerical values nrri, depleted, rvcr, arri. when preview clicked, chart showing x-axis labels jan jun. category grouping in chart periodname sorting done period_code. please help how show x-axis labels jan nov inspite of null values of y-axis.

you can seek this. right click on horizontal axis labels , select horizontal axis properties. on properties dialog select axis options set interval type field months.

reporting-services