Forum Discussion
Bar column conditional formatting - Dual chart
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
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 regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic
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