How to set default value to Slicer(Filter) ?
I have week number Slicer(filter).
If my current week is 47 then i want to set 47 in slicer.
I have below week filter for my report.
I want to set Week 47 selected by default.
Marais Kruger Thank you for the details.
I have one more query.
I have two grids on presentation i.e current weeks data & Previous weeks data grid and i have week slicer.
When i select week 47 from slicer, Current weeks grid should show week 47 data and Previous weeks grid should show week 46 data.
is there any way to achieve this?
Are you wanting to default the slicer to the specific value 47 or the latest (last) value dynamically?
Yes, there are ways to achieve the filtering requirements you specify. You will probably need to look at the use of Parameters and the LAG() function to get the previous time period from the slicer value you select.
Without knowing your data and exactly what you require, it is difficult to be more specific.