Forum Discussion
mrclay82
Helper II
Helper IIChange font based on performance
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 l...
mrclay82Helper II
Helper IIHi 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?