Definitely you can get this kinda analysis.
You need to create a calculated field to identify the difference and then you set the colour and shape based on the calculated field result!!
If you could post a sample workbook,it will be easy for helpers to help you!
See dashboard 2 on this spreadsheet. For the 7 day change you'll see I offset the lookup by 5 only. That's because of my data - it's only Monday to Friday.
Hope this gets you on the right track.
SAB-Share.twbx 45.4 KB
Thanks Vaishnavi. I got the idea. Using lookup function. Will try out.
Thanks Willem. This is helpful. Will try out.