Forum Discussion
truptis
Community Champion
Community ChampionDynamically 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...
andhiii079845
Solution Sage
Solution SageYou 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()))