Forum Discussion

3 Replies

  • andhiii079845's avatar
    andhiii079845
    Solution Sage
    3 years ago

    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's avatar
    Thennarasu_R
    Responsive Resident
    3 years ago

    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 




  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

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