Forum Discussion

mrclay82's avatar
mrclay82
Icon for Helper II rankHelper II
3 years ago

Change 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 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.

 



2 Replies

  • mrclay82's avatar
    mrclay82
    Icon for Helper II rankHelper II
    3 years ago

    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?