Conditional formatting on column chart with legend

[Marcin]

HI,

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 ? 

[v-piga-msft]

Hi @Marcin ,

Yes, if we add the legend value then we cannot use the feature conditional formatting for Clustered column chart.

By my tests and research, there is no good idea for your requirement.

Hope @Zubair_Muhammad has other ideas.

Best Regards,

Cherry

[Zubair_Muhammad]

@v-piga-msft @Marcin 

Unfortunately I don't know of a solution 😞

May be.. we can create a customised visual using "Charticulator" to suit specific needs.

https://charticulator.com/docs/getting-started.html