Chart Control in SSRS

In SSRS we many rich Data Visualization controls---like Chart,Data Bar,Sparklinke,Gauage.

advantages :
vast infomation is represented through Data visualization control/Graphical representation.

Chart
Bar Chart
Sparkline
Gauge

Working with Chart :

Chart Report contains three sections:

1.  Data Section (Values): Represent actual data means values along Y-Axis. Values must be a numeric data type.

      2.  Category Section (Category groups): It gives group wise information along X-Axis.
      3.  Series Section (Series Group) The chart control can also layer multiple sets of data onto the same chart. Each layer is called a series

Prepare a Dataset 

SELECT  DimSalesTerritory.SalesTerritoryCountry, DimDate.CalendarYear, DimDate.CalendarQuarter,FactInternetSales.SalesAmount

FROM DimSalesTerritory INNER JOIN

FactInternetSales ON DimSalesTerritory.SalesTerritoryKey = FactInternetSales.SalesTerritoryKey INNER JOIN

DimDate ON FactInternetSales.OrderDateKey = DimDate.DateKey

Chart :

now

Grouping Yearwise overwise graph ---Serices

 

i customized as above chart. and Each year is a data point(we can consider as data bar) with different colors(we can customize these yearwise colors also). multiple data points is possiable in chart control

Note:
This bar chart showing Yearwise ---as --color bar but not amount, sales is SUM Amount of the Year.