Locking Slicer Position

[campelliann]

Hi, 

So I was asked to have a date slicer in which the default position is the "current month" ("Mes Atual"). The user must be able to change it (if he wants to see some other month) so I created a text field. 

The thing is this, as the slicers grows with more dates, instead of getting the first picture (because I want the user to immediatly see the current selection), it gets the second (which is not intuitive because he cannot see that the Current month is the selection)

Is there a way to keep the slicer in the default position so the user always sees the first image (the right side of the slicer) instead of the left.

[amitchandak]

@campelliann , Create a new column in date table like

Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)

Select and Save on this month. Also change the order to ascending