Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Welcome to my blog. I work as Database lead at Synaptic Digital. Hope you find some interesting stuff here.
Browse by Tags · View All
BRH 17
SQL Server 15
#SQL Server 11
#BI 10
#TSQL 8
TSQL 8
BI 7
SSRS 6
#SQLServer 6
SSRS 2008R2 5

Archive · View All
January 2011 6
December 2010 5
September 2012 4
May 2012 4
March 2011 4
November 2012 2
October 2012 2
January 2012 2
February 2011 2
November 2010 2

Change color of column/bar in SSRS column/bar chart dynamically

Dec 7 2010 2:33AM by Chintak Chhapia   

As in previous post, we have added an average trend line to Column/Bar chart.

Now, suppose we want to change the colours of columns/bars such that, the columns below average should in different colour and columns having value above should be in other colour.

How to change the bar colour based on the some value has been documented here by Jason Thomas.

To find the average value, we can add report parameter Average and set the formula to =Sum(Fields!SalesAmount.Value,"SalesDetails") /  Count(Fields!MonthNumber.Value,"SalesDetails")

 

So,  As per above mentioned post,  we need to select the SalesAmount series in chart and add a following expression for Color property.

=iif(Sum(Fields!SalesAmount.Value) > Variables!Average.Value,"SeaGreen","Maroon")

Now, when we preview the report, we can get following chart

Tags: BRH, #SQL Server, SQL Server, #BI, SSRS, #SSRS, #TSQL, MSBI, Reporting, #MSBI,


Chintak Chhapia
40 · 5% · 1473
1
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

"Change color of column/bar in SSRS column/bar chart dynamically" rated 5 out of 5 by 1 readers
Change color of column/bar in SSRS column/bar chart dynamically , 5.0 out of 5 based on 1 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]