cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NewbieJono
Helper II
Helper II

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 working day.

 

 

1 ACCEPTED SOLUTION
V-pazhen-msft
Community Support
Community Support

@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())
Vpazhenmsft_0-1634524151205.png

 

 

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

View solution in original post

3 REPLIES 3
V-pazhen-msft
Community Support
Community Support

@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())
Vpazhenmsft_0-1634524151205.png

 

 

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

View solution in original post

sm_talha
Resolver II
Resolver II

why are you showing sat sun on your slicer ? you can strict the view and show only working days to the user by multiple ways. You can add your Days field to the filter pane as "Filter on this Page" and select all days but uncheck sat and sun, now user will not be able to see or select sat/sun. Check the attached screenshot.  

 

sm_talha_0-1634188680167.png

 

 

you can also go by the second way you already suggested. You can modify your measure to return statement of your choice upon selection of sat or sun. Please see the following measure. 

 

Working Day Measure =
IF(
    SELECTEDVALUE( Dates[DayName] ) IN { "Saturday", "Sunday" },
    "Not a working day",
    [Your Measure]
)

 

amitchandak
Super User
Super User

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

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.