Dynamically select date slicer

[truptis]

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.

@amitchandak @lbendlin 

[lbendlin]

As a super user you should stop using slicers. 🙂 Use the filter pane.

[Thennarasu_R]

Hi @truptis 

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

        var __Yr=FORMAT('Date'[Date],"YYYY")

Return

     Var _Result=

        IF(__Mon=FORMAT(TODAY(),"MMM"),IF(__Yr=FORMAT(TODAY(),"YYYY"),"Current Month",FORMAT('Date'[Date],"MMM")))

Return

IF(_Result=BLANK(),FORMAT('Date'[Date],"MMM"),_Result)

@amitchandak 

If have helpful to you Give kudos and accepeted a solution.

Thanks,
Thennarasu 

[andhiii079845]

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