Forum Discussion
Helper VLast Week Number Selected in Slicer
Hi,
I have a WeekNumber Column in my Calender Table for the year 2020 and 2021,
Now, if the user selects the year 2021, from the slicer on the Home page and then navigates to the Weekly page it should show the last week data and the week number should be pre selected in the Week Slicer, and the user can also change the week accordingly otherwise it should show the last week data as week number is selected in Slicer.
I have created a Week Type Column, which shows "Last Week" Dates and "This Week" Dates
But, I am unable to set the Last Week, Week Number as pre selected in Week Slicer.
amitchandak
Any Help ??
I believe i do! 🙂
What i mean is that you need to create a new column to use in the slicer and make sure that this column is sorted in a way where the "Last week" value always will be located at the top.
Like this:
Br,
J
6 Replies
- tex628
Community Champion
Hi MH3,
I'd say you need to make sure that the value for last week is always the first instance in that filter. Currently it appears that the first value is "Week - 1 - 2021" as you have an ascending sorting order in the slicer.
If you change that to decending you will instead either get the current week, or some week in the future depending on how the filtering looks.
My recommendation is to create a calculated column where you make sure that the "Last week" value is going to be the first one when you sort either acending or decending.
Hope this helps,
Br,
J
MH3tex628 Thanks for your reply.
But, actually the Week Number column has only Week Number for the whole year from 1 to 52 /53
and the column Weektype has Values of Week, Last Week and This Week as you can see in the Table ScreenShot.
I acutally want that slicer to be pre selected of that last week, week number i.e Week -12- 2021 for the month of March which is 22 to 28 March.
hope you understand- tex628
I believe i do! 🙂
What i mean is that you need to create a new column to use in the slicer and make sure that this column is sorted in a way where the "Last week" value always will be located at the top.
Like this:
Br,
J