My requirement is a line chart where X-axis is plotted with week(six weeks) and Y-axis is a measure. Now the week is put up as a dashboard filter, where choosing on a particular week(say week 10), then the weeks that’s displayed on the x-axis should have the previous six weeks’ data(wk5 - wk10).
Could you please help me with any posts with such a requirement?