Forum Discussion
Conditional formatting by comparing yesterday value
Hello All, I have 2 measures that shows today total and yesterday total. My aim is to compare yesterday total to the today total , and highlight the today value in red or green depending on...
On the diff of two, you can use color formatting.
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting
Or you can create a color measure and use that after choosing "field" in conditional formatting
Color = if([Sales Today] -[sales yesterday]>0,"green","red")
On the diff of two, you can use color formatting.
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting
Or you can create a color measure and use that after choosing "field" in conditional formatting
Color = if([Sales Today] -[sales yesterday]>0,"green","red")