Forum Discussion
Helper IOnly Highlight that meets a certain threshold weekly
hi,
I was curious if it possible to create a report where the only items that show up that meet a certain threshold when the data is refreshed. I have provided a small sample set for reference along with a example below.
| 7/20/2022 | 7/21/2022 | 7/22/2022 | 7/23/2022 | 7/24/2022 | 7/25/2022 | 7/26/2022 | 7/27/2022 | 7/28/2022 | |
| Week 1 | Week 1 | Week 1 | Week 2 | Week 2 | Week 2 | Week 3 | Week 3 | Week 3 | |
| Item A | 3 | 10 | 14 | 3 | 2 | 3 | 15 | 2 | 3 |
| Item B | 3 | 4 | 5 | 21 | 2 | 2 | 15 | 2 | 2 |
| Item C | 4 | 10 | 12 | 12 | 2 | 2 | 2 | 2 | 2 |
I want to be able to show where there is a variance of more than 30% between the weeks. So if the difference between week 2 and week 1 there is a 30% difference, it will highlight, but if it is less than 30%, it will not highlight. I have already created a daily threshold, but it doesn't seem to work if i group the day's together into weeks. See below for my threshold for daily. The week names and days are in the Date Table.
Let me know if you have any questions or comments. Happy to explain more!
see attached.
3 Replies
- lbendlin
Super User
This is a standard Week-over-week pattern and you can use conditional formatting for the highlighting.
However your sample data is in an unfortunate format, not conducive for processing. At the minumum you should unpivot it to convert it from wide to long.
Your sample dates also do not agree with your week numbers. Either omit the week number and calculate it from DAX, or provide correct sample data.
- lbendlin
see attached.
