Forum Discussion
Conditional Color Grafica Power BI
Good evening my friends,
I'm trying to color the bars following a conditional IF, the data if the bars exceed the value of 70 are marked in green otherwise they are marked in red, but at the time of coloring there is data that is below and I mark them in green.
I did create a measure called Maximus = 70
| my | value |
| January | 62,00 |
| February | 68,00 |
| March | 64,00 |
| April | 89,00 |
| mayonnaise | 58,00 |
| June | 92,00 |
| July | 66,00 |
| August | 91,00 |
| September | 62,00 |
| October | 81,00 |
| November | 67,00 |
| December | 83,00 |
3 Replies
Syndicate_Admin , looking at your table measure would be
Barras_OEE = IF ('OEE measurements per line' [value] > =70 ; "#adff2f"; "#ff4b2f")
if this % column, make sure [Maximum OEE] is .7 , then this should work
Barras_OEE = IF ('OEE measurements per line' [% OEE]> = [Maximum OEE]; "#adff2f"; "#ff4b2f")
use this in conditional formatting using field value option
i'm doing what exactly you say.. but sabrias xq me is coloring colors in which they do not meet the condition?
Hi Alexgamb20,
Can you please share a pbix file with some dummy data and expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
