Forum Discussion

MH3's avatar
MH3
Icon for Helper V rankHelper V
5 years ago
Solved

Last 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 ...
Need Help
Show and Tell
Tips and Tricks
  • tex628's avatar
    tex628
    5 years ago

    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

tex628's avatar
tex628
Icon for Community Champion rankCommunity Champion
5 years ago

Well it's the default functionality of the single select slicer to use the first indexed value in the slicer column. You will meet issues if you allow users to save filter applications in service, as this will override the default functionality so you will either need to remove that possibilty or live with the fact that user filter selections will affect the state of the report.

Br, 
Johannes

MH3's avatar
MH3
Icon for Helper V rankHelper V
5 years ago

tex628  Yes, I am agreed to that fact, if the user changes the slicer value it will be saved with that selection.
But, is there any kind of workaround, if the user navigates back to that weekly report, the slicer should reset to the default value, i.e the first value?

Any idea