Creating Stacked Bar charts in SSRS

Question

I would like to create a stacked barchart in SSRS.

I have following data.

Id  Year value
1  2005  990
1 2006 888
2 2005 986
2 2006 875
3 2005 970
3 2006 865

I would like these 3 ids to be displayed in the same bargraph, with years stacked to a particular entity (based on ids). The number of years would be same.

something like below:

year 1  year 2           year 1 year 2     year 1 year 2
entity 1                  entity 2          entity 3       

I tried finding solution online but could not find anything related to it.

Can you please help. Thanks a lot.

Answer 1

You can add row_number to your dataset query and then drag the Id and row_number fields to the Category Groups. Id is at the top of category group. Change the row_number group label to Year field. You will get the expected result.