conditional formatting of clustered column/bar chart with multiple series of values

[Anonymous]

Hi, I have a clustered column chart with 3 series of data: say Prop, Non-Prop & Total, where Total = Prop + Non-Prop (all measures/calculated column). I'd like to show Prop & Non-Prop in distinct colors. I'd like to show Total green however if it is >0 and red if it is <0. I can't see the conditional formatting option with the following settings:

Any ideas how to accomplish this please? Thank you.

[v-eachen-msft]

Hi @Anonymous ,

Conditional formatting feature current doesn't works on clustered column chart visual. You can vote for this idea.

Or you can download an earlier version Power BI(earlier than May 2018).

[amitchandak]

Check

https://community.powerbi.com/t5/Desktop/Conditional-formatting-in-a-clustered-column-chart/td-p/423...

[Anonymous]

@amitchandak i checked that prior to posting. it doesn't have the answer. i don't see color saturation field either, and having multiple series of values in a clustered column chart removes the option to add conditional formatting to a particular series.