Data color based on rules

[Vickram]

I have 16 indicators and each has its own benchmark value which keeps on changing. I want to set up the color of key card of each indicator based on its value compared to the benchmark value. Currently the Color rule (as below) only accepts numerical input. Is there anyway I can achieve this? 

I have read a post about creating measures to this resolve this issue. Does it mean i have to create 16 measures; one each for an indicator? 

I am new to Power BI, any help will be appreciated.

[amitchandak · Accepted solution]

@Vickram , In case you need to deal with only numbers rules can help you.

In case you want complex rules then you can use color measure. If the same measure can be applied at multiple places then you need one. else you need different combinations or measures.

examples measure

Color sales = if(AVERAGE(Sales[Sales Amount])<170,"green","red")
Color Year = if(FIRSTNONBLANK('Table'[Year],2014) <=2016,"lightgreen",if(FIRSTNONBLANK('Table'[Year],2014)>2018,"red","yellow"))

Color  = if(FIRSTNONBLANK('Table'[Year],2014) <=2016 && AVERAGE(Sales[Sales Amount])<170 
,"lightgreen",if(FIRSTNONBLANK('Table'[Year],2014)>2018,"red","yellow"))
Color sales = if([Sales Today] -[sales yesterday]>0,"green","red")

color =
switch ( true(),
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity1" && sum('Table'[Value]) >500,"lightgreen",
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity2" && sum('Table'[Value]) >1000,"lightgreen",
// Add more conditions
"red"
)

Refer

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values