Forum Discussion
Line and column chart - column conditional format based on line value
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 ?
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.
2 Replies
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.
v-xuding-msftthanks a lot, works great 🙂