Forum Discussion

campelliann's avatar
campelliann
Icon for Post Patron rankPost Patron
5 years ago

Locking Slicer Position

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 ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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