Skip to main content
Microsoft Idea

Power BI

Needs Votes

Restrict Calendar in date slicers please

Vote (1) Share
Rob's profile image

Rob on 20 Dec 2018 17:22:16

When using a slicer to select dates via a calendar, it would be really handy if there is an option to restrict which days are visable. For example when I click the first input box a calendar pops open which is nice, but I only want the user to be able to select sundays, all other days should not be selectable to the user.

Sundays could maybe have a different colour background, or non-selectable days be slightly greyed out to make it clear to the user as well.

This could be done by a new option in date slices which you could restrictions, and allow the user to supply a date heirarchy of choice (by years, by Qrt, or by Month, week, day of week) and then in the format option allow the user to do colour options based on the restrictions.