Forum Discussion
Solved
Dynamically filter slicer interval end date
Hi, I`m trying to set dynamically the end field of a slicer date. Like this: I tried this: DateEndMonth = IF(dw_ds_staffing_current[start_date]<=EOMONTH(TODAY(),0),dw_ds_staffing_curren...
- yo_peralta23 This is a common request. You could try voting for this or a similar request on Power BI Ideas, or post your own idea: https://ideas.powerbi.com/ideas/idea/?ideaid=0eab4ba7-b039-4785-9414-b8c94ab06e25
As a workaround, you could add a page level filter based on date, but as you have discovered this will filter all future data (I would suggest simply using Date as the page level filter and set to Past 5 years as a relative date filter (or 2 years or 10 years depending on your data). Unfortunately, this means you'll never have future dates, but it also means your slicer will only go as far as today every time you open the report.
yo_peralta23 This is a common request. You could try voting for this or a similar request on Power BI Ideas, or post your own idea: https://ideas.powerbi.com/ideas/idea/?ideaid=0eab4ba7-b039-4785-9414-b8c94ab06e25
As a workaround, you could add a page level filter based on date, but as you have discovered this will filter all future data (I would suggest simply using Date as the page level filter and set to Past 5 years as a relative date filter (or 2 years or 10 years depending on your data). Unfortunately, this means you'll never have future dates, but it also means your slicer will only go as far as today every time you open the report.
As a workaround, you could add a page level filter based on date, but as you have discovered this will filter all future data (I would suggest simply using Date as the page level filter and set to Past 5 years as a relative date filter (or 2 years or 10 years depending on your data). Unfortunately, this means you'll never have future dates, but it also means your slicer will only go as far as today every time you open the report.