Forum Discussion

campelliann's avatar
campelliann
Post 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 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.

 

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super 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