Conditional formatting with a comparaison of 2 number fields

[Anonymous]

Hi guys,

In a table, I would like to set a conditional formatting on a field X  if   Y < Z. Y and Z are numbers.

After many researchs I have not found anything, it seems not developed yet by Microsoft.

Do you have some workaround to share please ? 🙂

Thank you

[amitchandak · Accepted solution]

@Anonymous , You can create a color measure

color measure = if([Y] < [Z] , "Green", "red")

You can use that in conditional formatting/data color /. In advance option choose "Field value" and use this meausre.

As DAX has pnly one data type of column so checking isnumber will not add any value.

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