SSRS Tutorial 61 - Highlight Columns in Chart for Max and Min Values in SSRS Report

In this video of SSRS Tutorial " How to Highlight Columns in Chart for Max and Min values"
we will learn

How to write Group by Select Query for Dataset
How to create Column Chart Report in SSRS
How to use Expressions on Data Series to change the color of Column for Max and Min Values

Expressions used in this video
=IIF(Fields!TotalItemsSold.Value=max(Fields!TotalItemsSold.Value,"DSET_Sales"),"Green",IIF(Fields!TotalItemsSold.Value=min(Fields!TotalItemsSold.Value,"DSET_Sales"),"RED","YELLOW"))

Please visit our website
for other technology tutorials such as
SQL Server DBA Tutorial
SQL Server Integration Servives ( SSIS) Tutorial
TSQL Tutorial etc.

[ranganatha]

Thank you so much for this tutorial, its very clear explanation to understand each level people .

[dharaninathvallu]

How we can apply the same colors to the legend by saying red is min value and green is max value and so on

[s.ifreecoachinginstitute]

Small doubt bro how write percentage formula