sum({<Year=,[Month Name Short Year]=,date_con ={'>=$(=addmonths(max(date_con),-5))<=$(=max(date_con))'},[Metric_ID] ={'qq_001'} >} Result)/1000
To change the bar colors i had done with the following changes as below
So ,to do this i had gone to the Properties -->Expressions Tab--->Under each Expression --->Clicked on Background Color
So by changing the above expression , i am using the below expression in background color expression as
if(sum({<Year=,[Month Name Short Year]=,date_con ={'>=$(=addmonths(max(date_con),-5))<=$(=max(date_con))'},[Metric_ID] ={'qq_001'} >} (Result)/1000)>> 50,blue(),red())
But i am not getting the answer to change the bar colors