Forum Discussion
Conditional formatting based on average of previous week value
Hi, I have a table that has daily scores 1-10 (see below). I am currently displaying it as an average value of the week.
I am trying to create conditional formatting with values below. It shows the average of the values in the previous week. I would like it to turn green if the value is higher than the average before and red if it is lower. Can that be done? eg. the last two values on the bottom row would be red.
2 Replies
Hi,
Try this measure:
Color = IF([AverageCW]>=[AveragePW], "Green", "Red")
Notes:
[AverageCW] --> Your measure with the average of each week
[AveragePW] --> Your measure with the average of previous week
And after that apply that condicional formating for your measure, using this path:Hi, thanks. I am having an issue setting up the measure since my values are not Averaged as a measure but rather I take the Average of all values (see below). Could you suggest how to go about it?
