Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
5 years ago

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...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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

 

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    5 years ago

    i'm doing what exactly you say.. but sabrias xq me is coloring colors in which they do not meet the condition?