Forum Discussion
Helper VLast Week Number Selected in Slicer
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
Community ChampionI 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
Helper Vtex628
Well as per your workaround, I have done this
WeekNumberTest = if(DimDate[Week Type]="Last Week", "0 - Last Week",DimDate[WeekNumber])
and I dropped that field into the Slicer
The Date Range on the Top Right shows the correct Date Range from 22 to 28 March. 😄
Will this work as a professional workaround? or it's just a used case scenario?
- tex628
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