Skip to main content
Microsoft Idea

Power BI

Under Review

Relative Date filter week Mon-Sun

Vote (2305) Share
derek's profile image

derek on 24 Jul 2017 21:41:33

the Relative Date filter options for the calendar week goes from sunday through saterday.

Most companies I know, go from Monday through Sunday. Please give us the option to choose in the filter, or set it though the localization.

Comments (325)
derek's profile image Profile Picture

Bus Intel on 21 Oct 2020 06:08:29

RE: Relative Date filter week Mon-Sun

Calendar weeks options is really useful but useless if our week does not start on a Sunday (our weeks starts on a Saturday - payroll period start - so this needs to be configurable to any day of the week

derek's profile image Profile Picture

Jan Stefka on 23 Sep 2020 10:33:20

RE: Relative Date filter week Mon-Sun

This is a must to have feature. Please enable it. Thanks, Jan

derek's profile image Profile Picture

Markus Knutsson on 22 Sep 2020 16:33:01

RE: Relative Date filter week Mon-Sun

Hi all

Can this setting please be enabled?

derek's profile image Profile Picture

Marc Ritchie on 14 Sep 2020 08:10:35

RE: Relative Date filter week Mon-Sun

I find it unbelievable that 1) the default for a week is not Monday to Sunday and 2) there is STILL no option to change this. How much time is wasted by businesses having to create custom code to get this to work

derek's profile image Profile Picture

Carina Cao on 09 Sep 2020 16:00:39

RE: Relative Date filter week Mon-Sun

it's been 3 years i can't believe this functionality hasn't come true yet

derek's profile image Profile Picture

Cecilia Ryding on 08 Sep 2020 09:17:48

RE: Relative Date filter week Mon-Sun

Yes, it is crazy that it is not available!

derek's profile image Profile Picture

Sean McCormick on 12 Aug 2020 01:45:38

RE: Relative Date filter week Mon-Sun

Truly confused why this isn't available.

derek's profile image Profile Picture

Sean Douglas Thomsen on 11 Aug 2020 12:41:08

RE: Relative Date filter week Mon-Sun

I work in Denmark and here a week always starts on Monday. Starting it on Sunday causes a lot of confusion for customers.

derek's profile image Profile Picture

Power BI User on 10 Jul 2020 17:22:21

RE: Relative Date filter week Mon-Sun

It should use the localisation settings, or have the option to define it within the report

derek's profile image Profile Picture

Amit Chandak on 10 Jul 2020 17:21:59

RE: Relative Date filter week Mon-Sun

Week can start from any day. Weekday and weeknum functions should be supported on this. +1
I have blog where you can how to get all weekday calnedar

https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Power-BI-Turning/ba-p/1187482