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_current[start_date],BLANK())
And set it in the filter pane as not blank:
But it cut off all future data and the slicer has no effect when I select a date later than 30 sept 2020 (in case of the current month is sept 2020)
Thanks in advance
- 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.
1 Reply
- 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.