Need DAX for Conditional Formatting

[robarbie]

Hi,

I need help creating a DAX measure to create conditional formatting based off the ADC Budget field.  If the other fields totals   Daily Census, MTD ADC, and WDT ADC are less than the ADC Budget they are red, if greater it is green.

The screen shot below is a little hard to see.  The ADC Budget field has the 178.000 at the top.

Thanks in advace for any assistance provided.

Best regards,

Rochelle

[amitchandak · Accepted solution]

@robarbie , you can create a color measure 

example

Switch(True(),

[WDT ADC] < [ADC Budget] , "red", "green")

more examples

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

And use that in conditional formatting using the field value option

refer for steps

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
https://www.youtube.com/watch?v=RqBb5eBf_I4