How to avoid unwanted columns values in Chart in SSRS -


i have report have create basic chart report.

my data in following way

month sales
jan 100
feb 200
mar 300
apr 500
may 750

now want create chart in ssrs has display in below figure
enter image description here

instead of displaying columns values(jan, feb, mar, apr, may, jun) want show data jan , march, how can done.

if take months in category groups showing values (jan, feb, mar, apr, may, jun).

right click month category group, select category group properties, add filter following settings:

expression  [month] operator    in value       jan, mar 

edit: assumes month field returned text. if date field, need modify comparison value accordingly.


Comments

Popular posts from this blog

javascript - Jquery show_hide, what to add in order to make the page scroll to the bottom of the hidden field once button is clicked -

javascript - Highcharts multi-color line -

javascript - Enter key does not work in search box -