default Slicer

[AzaharoddinSk]

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?

[AzaharoddinSk]

@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]

@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. 

[ValtteriN]

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/