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!
Go to 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
View solution in original post
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
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.
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.
@Thejeswar no, I have all the 52 weeks in my calendar, I think the solution provided by @sailkitty is more correct.
Thank you both!
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Find out where you can attend!