Need DAX for Conditional Formatting

robarbie — Mon, 03 May 2021 16:33:58 GMT

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

Re: Need DAX for Conditional Formatting

amitchandak — Mon, 03 May 2021 17:17:22 GMT

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-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
https://www.youtube.com/watch?v=RqBb5eBf_I4

topic Re: Need DAX for Conditional Formatting in DAX Commands and Tips

Need DAX for Conditional Formatting

Re: Need DAX for Conditional Formatting