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

1. How to write Group by Select Query for Dataset
2. How to create Column Chart Report in SSRS
3. 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"))

How to Highlight Columns for Max and Min Values in Column Chart in SSRS Report - SQL Server Reporting Services ( SSRS) Tutorial

  Check out related Posts / Videos in this Chapter  

• How to create Matrix Report in SSRS
• How to use Sub Report Report Item
• How to Create Column Chart in SSRS Report
• How to Create Stacked Chart Report in SSRS
• How to Display Total on top of Stacked Chart in SSRS Report 
• How to Combine Column Chart with Line Chart in SSRS Report  
• How to Plot multiple lines on Same Graph from Same Dataset in SSRS Report
• How to Custom Color Columns in Column Chart in SSRS Report
• How to Create Pie Chart in SSRS Report 
• How to Display Percentage in Pie Chart in SSRS Report 
• How to Change Data Labels Positions in SSRS Report
• How to Show Data Labels in Tooltip on hover in SSRS Report 
• How to Change the Width of Columns/Bars in SSRS Report 
• How to Create Bar Chart in SSRS Report
• How to Create Bar Stacked Chart in SSRS Report
• How to Create Area Chart in SSRS Report 
• How to Create Scatter Chart in SSRS Report  
• How to Create 100% Stacked Column / Bar Chart in SSRS Report
• How to Create Line Chart in SSRS Report
• How to use Gauge in SSRS
• How to use Data Bar in SSRS Report
• How to use Spark-line in SSRS Report
• How to make use of Indicator in SSRS Report
• How to create SSRS Report with Dynamic Columns ( When Definition of Source Table/View Change very often)