Forum Discussion
adjusting week slicer for range
i have a year slicer and a week slicer and have a page filter of last 365 days so when i select year 2021 it shows me the weeks passed and the current week in the slicer and when i select 2020 the weeks which are left in 2021 will come in the slicer for 2020
and for the report i will always be selecting a range of weeks
my problem is that i also want to select week range of the type 2020-52 to 2021-13 which means i want the data to be from week 52 of 2020 to week 13 of 2021 but that dosent work in this scenario
i do not want the slicer to change to multiple check boxes because then it will be tidious to select a big range
Is there any way to achieve this?
1 Reply
- amitchandak
Super User
Anonymous , You need to use a year-week slicer like YYYYWW, But that might show values like 202054 or 202099 while scrolling. You can try to use a column or measure at the visual level to restrict the values. But For between this might not work well
You can also explore timeline slicer https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa104380786?tab=overview
