Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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?
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:
Proud to be a Super User!
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |