Line and column chart - column conditional format based on line value

[Anonymous]

Hello,

Doing some research I've found there is no possibility to conditional format Line and column charts.

I would like to format Columns ⇾ when the value of column is greater than value of line, column will change color.

Is there any workaround / custom visual to achieve this ?

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

I create a simple sample. Please reference it to modify the formula based on your actual situation.

Compare =
VAR a = SUM ( 'Table'[Sales] ) 
RETURN 
IF ( a >= [Measure], "Green", "Red" )

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@v-xuding-msftthanks a lot, works great 🙂