Change font based on performance

[mrclay82]

Hi,

I have a matrix showing the [performance] for each salesperson grouped by year week.

I would like to change the font color to yellow for the last yearweek (202335) if the performance is lower than the week before.

In addition, if the performance has declined for two weeks in a row, I would like to change the font to red.

So I need two measures for this.

Please example.

Thanks in advance.

[mrclay82]

Hi @eliasayyy ,

Yearweek is a column from a Date table

[Performance] is a measure based on a Transaction table

Connected with one to many.

Not sure what you need to know?

I thought to write a measure or two measures and perhaps using variables to give me one output for “Yellow” and one for “Red” and use that measure in conditional formatting.

Something like IF(currentweek < lastweek, 1, “ “) Where 1 = Yellow. Need help defining currentweek and lastweek.

IF( currentweek<lastweek and lastweek<theweekbefore, 2, “ “) Where 2 = Red. Need help defining theweekbefore.

And of course calculate the [performance] measure for each one.

Does this help?

[eliasayyy]

hello @mrclay82  can you please share a sample data of hwo your dataset looks like