Forum Discussion

NewbieJono's avatar
NewbieJono
Post Partisan
4 years ago
Solved

Between Slicer

This is a long shot, but can you prevent people selecting sat and sun on the between slicer option.   or can i include somehting in my measure to produce an error saying date selected is a non work...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    NewbieJono 
    I would recommend you to create a new weekday column as the slicer.


    If you only have Weekdayname column you can create the following column.

    working weekday = IF([Weekdayname]<>"Sun"&&[Weekdayname]<>"Sat",[Weekdayname], "Weekend")
     
    Or if you also have a Date column:
    working weekday = IF(WEEKDAY([Date],2)<=5,WEEKDAY([Date],2),BLANK())
    or
    working weekday = IF(WEEKDAY([Date],2)<=5,[Weekdayname],BLANK())

     

     

    Paul Zheng _ Community Support Team
    If this post helps, please Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
4 years ago

NewbieJono , as of now there is no action popup is supported. You can display messages on the title or card if needed