How to highlight Maximum and Minimum Column Chart Bar in Power BI?

[RahimZulfiqar]

I have created Column chart in POWER BI. All the bars in the column chart are with same color. Now I need that Maximum Bar should have fill color of GREEN and Minimum bar fill color in RED and the remaining in any one color. How to do that?

[Zubair_Muhammad · Accepted solution]

@RahimZulfiqar

You can do it with the help of color saturation property of column chart

Please see the attached file

I defined a simple MEASURE and put it in the Color Saturation Field

Measure =
SWITCH (
    TRUE (),
    SUM ( Table1[Values] )
        = CALCULATE ( MAX ( Table1[Values] ), ALLSELECTED ( Table1[Category] ) ), 1,
    SUM ( Table1[Values] )
        = CALCULATE ( MIN ( Table1[Values] ), ALLSELECTED ( Table1[Category] ) ), 2,
    0
)

[RahimZulfiqar]

Any step by step tutorial ?

[Zubair_Muhammad]

@RahimZulfiqar

I only learnt this technique by trial and error after your post

Thanks for this question

[Zubair_Muhammad]

@RahimZulfiqar

sorry i didn't mention it earlier

the colors can be chosen from the data colors section