Chart to have all months exactly like the table

hello experts,

as move deeper designing reports in ssrs, stuck @ many areas , looking @ other forums , trying things works , did not.

here have right now

screen shot of table in report:

graph being drawn :

notice graph axis-x not have months

here 2 datasets created, 1 called financialgraph table above

table image:

the graph drawn dataset below called dataset2 has specific months x-axis:

question: how draw graph here in ssrs dataset called financialgraph? easy in excel

please help

hi joylili,

according requirement, want draw graph dataset financialgraph , right?

you can achieve goal unpivot function. unpivot function change structure of dataset(financialgraph), if want display data previous table, need use matrix achieve goal.

you can use unpivot function configure dataset financialgraph below

select        id, type,month, amount            (select        id, jan, feb, mar, apr, may, jun, jul, aug, sep, oct, nev, dec,type                                      table_3282) tab unpivot (amount month in (jan, feb, mar, apr, may, jun, jul, aug, sep, oct, nev, dec)) 

then dataset below, , can draw graph these fields

because want see months name, need configure category group properties delete sorting expression , configure horizontal axis properties set interval 1.

you can result below

by way, if want table created dataset(financialgraph), need use matrix display previous structure of table. need create matrix below, right click month in column groups configure group properties , delete record in sorting option. structure of previous table provide.

as alternative, if don’t want use unpivot function change structure of dataset, can try union function below add months data dataset2 , draw graph based on dataset2.

then draw graph dataset2.

if have question, please feel free ask.

best regards,

zoe zhi

SQL Server  >  SQL Server Reporting Services, Power View