Dynamically select date slicer

Question

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 selected.
&nbsp;
amitchandak&nbsp;lbendlin&nbsp;

andhiii079845 · Answer

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()))

thennarasu_r · Answer

Hi&nbsp;truptis&nbsp;For current Month want move slicer automatically created one Calculated Column in that column you need to set one text Name like "Current Month " or Any other name is your Wish. we can achieve this way only .I'm Achieve .Month 1 = Var __Mon=FORMAT('Date'[Date],"mmm")&nbsp; &nbsp; &nbsp; &nbsp; var __Yr=FORMAT('Date'[Date],"YYYY")Return&nbsp; &nbsp; &nbsp;Var _Result=&nbsp; &nbsp; &nbsp; &nbsp; IF(__Mon=FORMAT(TODAY(),"MMM"),IF(__Yr=FORMAT(TODAY(),"YYYY"),"Current Month",FORMAT('Date'[Date],"MMM")))ReturnIF(_Result=BLANK(),FORMAT('Date'[Date],"MMM"),_Result)amitchandak&nbsp;If have helpful to you Give kudos and accepeted a solution.Thanks,Thennarasu&nbsp;