SSRS - Stacked Column Chart With Positive and Negative values

Data-set for Graph(Inputs)

                              

Result

Solution

Step 1.

•  Add new SSRS project
• Right click on the Report then click -> Insert - > chart below screen will appear

• Click on the stacked column chart and click on
• Cancel if datasource screen appears
• You chart will look like below

                                             

Step 2

• Edit your data source add two column with logic of positive and negative value with center x axis value. for example see below query for this post

                                     

• Now your dataset will look like below with two extra column

                           

• Follow  below images to add new dataset for your report

                            Right click on the dataset and click on 'Add Dataset'

Dataset property window will appear click new for add new datasource

Datasource property window will appear click on edit to provide credentials

Provide all credential and test the connection

click ok in connection property and data source property and add the query we created in dataset property window and click on ok

Now expand the dataset you can see the all columns

Now right click on the chart and click on property and add the dataset.

Step 3

• Click on the '+' in the E values in chart data and add two columns you added like below image

After adding it will look like below

• Delete existing in category group and add the x axis column you want.

Final result will look like below

if you run your report will look like below

Step 4

• click on the Blank column in 'Chart data', open it property and change color to 'No color'

• Now right click on the another column field and click on the 'series property'

• Click on the fill and click on the expression

• The following expression will display "green' for above 50 and 'Red' for below 50

Step 5

• Right click on the major line property, A property window will appear like below

New window will appear and click on 'Grid interval' expression

Enter 50 to show line on 50 in y axis

Step 6

• Now in y axis property make min value as 0 and max as 100 and interval as 10

• Give title for chart 
• now run your report will look like below