Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
@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