Forum Discussion
Dynamically select date slicer
Hi All,
I wanted to select the dates dynamically depending upon which month it is.
I.e. - for example, currently it is March 2023 so in the date slicer historical dates till March 2023 must be se...
You can create a measure and filter your slicer with this measure: "IS NOT BLANK ()"
If you show "select all" in the options and set it active all shown dates are selected for default.
filter = COUNTROWS(FILTER('date','date'[Date]<=TODAY()))