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")
It's difficult to see, but in the formatting section of the visualizations pane, if you hover over one of the data color fields, you will get 3 dots to the right. Click the 3 dots to access conditional formatting.
https://docs.microsoft.com/en-us/power-bi/visuals/service-tips-and-tricks-for-color-formatting