Conditional formatting by comparing yesterday value

[Anonymous]

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 if it is higher or lower than the yesterday. 

I know conditional formatting feature on values in table or matrix but is it possible to compare with other column's actual value?

[amitchandak · Accepted solution]

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")

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...

[jstorm]

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

[camargos88]

Hi @Anonymous ,

Have you tried creating another measure comparing them and formatting it by this new one ?

Ricardo

[Anonymous]

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 ? 

[jstorm]

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.