Change colour/ formatting of only one bar in a visualisation

[sgupta22]

Hi everyone

Is there a way to change the colour/ formatting of only one bar in a bar visualisation? I know this can be achieved in Excel charts by selecting a single bar and changing its colour. Is there a similar option in Power Bi visualisations? For instance, I want to change the color of the 2022 bar, leaving bars for the other years the same.

Thanks

SG

[ppm1 · Accepted solution]

You can write a simple measure like this to return color values based on which Year is in context, and use it as the "Field Value" for bar color.

BarColor = IF(MAX(T4[Year]) = 2022, "Blue", "Yellow")

Pat

[sgupta22]

Thanks Pat.  This works! Appreciate your help 🙂