Color last bar expression need to place at where ?

[Paulyeo11]

Hi All

I have below expression from Mr Amit , working fine last time , it will help me color the last bar to Red :-

Color Last Bar = var _max = maxx(ALLSELECTED('Date'), 'Date'[YrMth Sort]) return if(max('Date'[YrMth Sort]) = _max, "Red")

I try to put the expression at legend of the chart , it does not work , i try data color also not working. Can some one share with me where i go wrong ?

Paul

[amitchandak · Accepted solution]

Hi@Paulyeo11 ,  This you can only use in data color. Not as a legend. Also conditional formatting in case of Bar Visual will not work with Legend