I would like to create a column chart , as exemple below, where I present Total sales by category but also split by months ( as legend in this case ). The measure is built to present last 12 month sales.
The problem I have is that I don't know If and how to add conditional formatting option on values, so that there were different colors for last Year month and current Year months.
I can do it when there is no legend, after I add Month to legend then the option is not available.
Any idea or custom visual ?