Data Bar in SSRS

Data Bar :  (Single value)

 The data bar is a new visualization (2008 R2) that essentially provides a bar chart to convey a lot of
information in a little space.
 Data bars are often used in table and matrices
 This enables you to easily compare the data in one row to another based on the relative length of their
data bars.
 Data bars can represent multiple data points, but typically illustrate only one.
 Data bars usually depict single value in a cell.
 We cannot add a data bars to a detail group in a table.
 By default when you create a databar you cannot see axis, legend etc.

Prepare a Dataset :

Select DimSalesTerritory.SalesTerritoryGroup,DimDate.CalendarYear,

SUM(FactResellerSales.SalesAmount) As SalesAmt

From DimSalesTerritory INNER JOIN

FactResellerSales ON DimSalesTerritory.SalesTerritoryKey

=FactResellerSales.SalesTerritoryKey INNER JOIN

  DimDate ON FactResellerSales.OrderDateKey=

DimDate.DateKey

GROUP BY DimSalesTerritory.SalesTerritoryGroup,DimDate.CalendarYear

Design :

then

Now observe it

Now we will make them Grouping SalesTerritory Group wise.

difference -- Yearwise

1. Yearwise

   

2. SaleTerritoryGroup

  

Compare the values(Numaric ) in row we have to use DataBar control.

it supporting Grouping Tablix or Particular column also possiable.