Last 6 weeks displayed as Week

[Emmy66]

Hi Everyone,

Attached is my pbix file which contains my data. The aim is to output the last six weeks in the other below (fig 1) instead of (fig 2) i.e showing week numbers. The visualisation will be the only visual to display last 6 weeks whilst others will only show the current week based on the selected date i.e. Friday of that week. This slicer will be based on DimDate[WeekEndFriday].

Any help on this will be appreciated.

Fig 1

Fig 2

https://drive.google.com/file/d/18JOrsIJnIMuQoRFC_8e0WRjDXixju0jA/view?usp=sharing 

[daXtreme]

Hi @Emmy66 

Here's how to do such things as explained by one of the Masters, Alberto Ferrari: Show last 6 months based on user single slicer selection - YouTube

All you'll have to do is to use weeks instead of months.

[Emmy66]

@daXtreme Thanks for your prompt response. I've seen the video from Alberto Ferrari, my question is that instead of having week #s, can it be replaced with Week, Week-1, Week-2, Week-3, Week-4 etc.

[daXtreme]

@Emmy66 

Why could it be not replaced with anything else that is an ordered dimension? Alberto only shows you some pattern, even though he uses dates. But it's the pattern that's important, not the specific example.

[Emmy66]

@daXtreme Thanks for your comment. The reason I'm trying to replicate that is because the business reports it in the format shown in Fig 1. My question is, is it achievable at all?