Forum Discussion
RahimZulfiqar
Advocate II
Advocate IIHow to highlight Maximum and Minimum Column Chart Bar in Power BI?
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 re...
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 )
RahimZulfiqarAdvocate II
Advocate IIAny step by step tutorial ?
Zubair_Muhammad
Community Champion
Community Champion
I only learnt this technique by trial and error after your post :smileytongue:
Thanks for this question
- Zubair_Muhammad
sorry i didn't mention it earlier
the colors can be chosen from the data colors section