Formating a matrix table based on dates.

[DamianWilliams]

On the below table, for each row, I have to conditionally format, where if the Satements sent is greater than the Statements due, the Font colour should be Red, and if it is lesser should be Green. How can I do that.

Statements Due	Statements Sent
31/10/2021	16/11/2021
30/09/2022	15/09/2022

[v-yueyunzh-msft · Accepted solution]

Hi , @DamianWilliams 

According to your description, you want to realize that if the Satements sent is greater than the Statements due, the Font colour should be Red, and if it is lesser should be Green.

Here are the steps you can refer to :
(1)We can create  a measure like this:

Measure = IF(MAX('Table'[Statements Sent])>MAX('Table'[Statements Due]) , "#FF0000", "#00FF00")

(2)Then we can put this measure on the "fx" in the "Cell Elements" of this Table visual:

For the 'Series' you can choose which column you want to selt the "Background color".

Then we can meet your need , the result is as follows:

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly