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
1 Reply
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