Create Data bar chart report in SSRS

Follow the below steps to Create Data bar chart report in SSRS

Use the below scripts to create dataset.

SELECT geo.StateProvinceName, sum(Fact.SalesAmount) as SalesAmount

       FROM FactInternetSales AS Fact

INNER JOIN DimSalesTerritory AS Sales on Fact.SalesTerritoryKey=Sales.SalesTerritoryKey

Inner join DimGeography as geo on geo.SalesTerritoryKey=Sales.SalesTerritoryKey

          group by geo.StateProvinceName

·         Right Click table column -> Insert -> Data bar

·         Click on data bar -> Select Values -> Sales Amount

·         Right-click the chart and choose 'Show Data Levels'

·         Save Report and Run the report.