Conditional formatting on column chart with legend

Question

HI,&nbsp;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.&nbsp;&nbsp;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.&nbsp;&nbsp;I can do it when there is no legend, after I add Month to legend then the option is not available.&nbsp;&nbsp;Any idea or custom visual ?&nbsp;&nbsp;

v-piga-msft · Answer

Hi&nbsp;Marcin&nbsp;,
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&nbsp;Zubair_Muhammad&nbsp;has other ideas.
Best Regards,
Cherry
&nbsp;
&nbsp;

zubair_muhammad · Answer

v-piga-msft&nbsp;Marcin&nbsp;
&nbsp;
Unfortunately I don't know of a solution :(
&nbsp;
May be.. we can create a customised visual using "Charticulator" to suit specific needs. 
&nbsp;
https://charticulator.com/docs/getting-started.html

lucasalcarde · Answer

Hello,hiSTILL NO SOLUTION?&nbsp;

ildashabani · Answer

Hello,&nbsp;No solution to this topic yet?&nbsp;

anonymous · Answer

We're also struggling with this issue, since we need to colour-code specific values less than 5 in order to denote they are not true values.&nbsp;

Forum Discussion

Conditional formatting on column chart with legend

5 Replies

Related content

Conditional Formatting using DAX

Conditional Formatting

Conditional Formatting

Matrix Row Conditional Formatting

Conditional Formatting