Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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 )
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 )
Any step by step tutorial ?
I only learnt this technique by trial and error after your post
Thanks for this question
sorry i didn't mention it earlier
the colors can be chosen from the data colors section
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |