Bar column conditional formatting - Dual chart

[Anonymous]

Hi Team,

I have done Line and clusterd column chart, if bar exceed in the line then highlight red colour else gray colour.

how do i fix it.

Thanks,

KV's

[selimovd · Accepted solution]

Hey @Anonymous ,

you can do the conditional formatting based on a measure.

In the measure you can check:

Bar Color = IF( [Bar Measure] > [Line Measure], "Green", "Red" )

Then you can use that measure for the formatting:

Conditional table formatting in Power BI Desktop - Power BI | Microsoft Docs

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic