Forum Discussion

AzaharoddinSk's avatar
AzaharoddinSk
Frequent Visitor
3 years ago

default Slicer

We have 4 years of data i.e from the past three years and a year of future data.

we need to add a slider slicer to the date field. The slicer should be selected default for the current month (MTD) is this possible by not adding an additional column in the calendar table?

Need Help
Please help

3 Replies

  • ValtteriN's avatar
    ValtteriN
    Community Champion
    3 years ago

    Hi,

    Here is one way to do this:

    Add this column to your calendar:

    This Month =
    var TW = DATEDIFF(TODAY(),'Calendar'[Date],MONTH)
    return
    If(TW=0,"Current Month",'Calendar'[Month]

    )


    Then use that as a slicer:

     

    I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

    My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

  • AzaharoddinSk's avatar
    AzaharoddinSk
    Frequent Visitor
    3 years ago

    ValtteriN, The requirement is I want a total  4 years of data in the slider slicer, and by default, it can only show the current month's data, and when I move that slider it can show as per selected dates in 4 years of data, is that possible?

    • ValtteriN's avatar
      ValtteriN
      Community Champion
      3 years ago

      AzaharoddinSk  I see, In that case there isn't an easy solution. You can default a slider to have values for only current month from the filter pane, but having a slider show automatically current month and then without users changing anything in the filter pane they could select values from last 4 years. This kind of combination of logics isn't really possible by only using a slider.