Highlight different color in chart

[45228238]

Hey -

I got a bar chart based  ( balance by Month Year). for e,g last 6 months Trend showing balance for each month. 

dimension: Date as Month - Year

Measure: Balance in USD

So I want highlight the latest month as different colour from rest of the months data.  e.g latest month bar as red and all other months as grey colour.

Thanks

[sam8 · Accepted solution]

There are ways to do this in Looker, but I don't think this sort of conditional formatting in bar charts is possible in Looker Studio.