Conditional formatting in cluster column chart

Question

I am having a cluster column charts which has target and value,If the value is above the target then chart must be red,otherwise green.How can I do this in Power Bi?

Answer 1

On visualization select for Line and clustered column chart 

and use the following measure

TargetColour = 

VAR Actual = SUM(Table1[Actual])
VAR Target = SUM(Table1[Target])

RETURN

IF(
    Actual >= Target,
    1,
    0
)

And under conditional formating use different colors

Enroll now in Power BI Certification Course to learn more.

Also, check out our YouTube video to know the data visualization basics and best practices with Power BI