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")
Hi Anonymous ,
Have you tried creating another measure comparing them and formatting it by this new one ?
Ricardo
I have not tried that.. I am actually looking for directins on how to create this measure and how to use it to change color ?
You can make a measure similar to
IF( [yesterday total] > [today total],
1,
0
)
Then in the conditional formatting area of data colors, you can use this measure as a rule.
