Conditional Color Grafica Power BI

[Syndicate_Admin]

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

and for bars use this Barras_OEE = IF ('OEE measurements per line' [% OEE]> = [Maximum OEE]; "#adff2f"; "#ff4b2f")

* OEE measurements would be the table below

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

[Anonymous]

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

[amitchandak]

@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]

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