Filter last x weeks

[Anonymous]

Hi all! I was wondering how to filter my x-axis in order to have only the last 10 weeks. 

As you can see below by default it shows all the 52 weeks of the year, and it's very ugly to watch.

I tryed to use an advance filter, but it only permitt to enter number and not formulas.

Sorry if it is a dumb question and thanks!

[Anonymous · Accepted solution]

HI- if you make a date slicer and select "Relative" as your slice type you select however many weeks, days, etc you want and it is dynamice to the data 

[Thejeswar]

Hi @Anonymous,

You can restrict the last 10 weeks using TOP N Filter as shown in the below image

The Top visual shows the data for all 52 weeks, while the bottom visual shows only the last 10 weeks

[Anonymous]

Hi @Thejeswar, thanks for the reply,

this is not exactly what I looking for, because I meant last 10 weeks starting from now, for example:

today we are in week 34, I want to show data from week 24 to week 34.

[Thejeswar]

Hi,

If you are having only 34 weeks data with you, filtering TOP 10 is still going to give last 10 weeks which is from 25 to 34 weeks.

[Anonymous]

@Thejeswar no, I have all the 52 weeks in my calendar, I think the solution provided by @Anonymous is more correct.

Thank you both!