expression language like in java to powerbi

[kyrpav]

Hello,

If i have some columns from database that i store thresolds and colors like  

Thresold	Color
>0.9	#00ff00
>=0.8 && <=0.9	#ffbf00
<0.8	#fb3318

Is it possible that i can parse the column and use it in Measure for conditional formating? By this i mean to check by thresold and return the color.

[amitchandak]

@kyrpav 

I doubt expression but you can always create a color measure with cole name of hex code with prefix # and use in conditional formatting

Example

Color Date = if(FIRSTNONBLANK(Table[date],TODAY()) <today(),"lightgreen","red")
if(FIRSTNONBLANK(Table[Value],"true") "true","green","red")


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")

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