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

Søren Toft Kirkegaard on 16 Mar 2021 07:57:13

RE: Relative Date filter week Mon-Sun

Pls fix! ;)

derek's profile image Profile Picture

Irina Vyshinskaya on 15 Mar 2021 03:37:28

RE: Relative Date filter week Mon-Sun

Microsoft, please make it happen!

derek's profile image Profile Picture

Jonathan Godshall on 05 Mar 2021 15:19:51

RE: Relative Date filter week Mon-Sun

This is crucial to all weekly reports. This should be a system setting in the background to allow for flexibility in the client's calendar configuration. Domo has had this ability for 3 years already. They also allow for a single fiscal year configuration to be set.

derek's profile image Profile Picture

Alex Tonkyn on 03 Mar 2021 07:22:32

RE: Relative Date filter week Mon-Sun

This was raised in 2017! I don't understand why the facility to choose a Saturday, Sunday or Monday week start has not been provided. We work Monday to Sunday.

derek's profile image Profile Picture

Luiza Oancea on 24 Feb 2021 12:14:17

RE: Relative Date filter week Mon-Sun

Why has nothing been done about this feature yet? :( The relative date filter is useless when week starts on sunday.

derek's profile image Profile Picture

Lotta Carlsson on 17 Feb 2021 15:03:53

RE: Relative Date filter week Mon-Sun

As said - this is an essential issue when it comes to relative date filters that otherwise is really good now.
But this drags the functionality down big.
Please add as soon as possible.

derek's profile image Profile Picture

MBO Consulting on 11 Feb 2021 11:27:25

RE: Relative Date filter week Mon-Sun

We need it now!!!

derek's profile image Profile Picture

Stephen Costanzo on 10 Feb 2021 21:17:05

RE: Relative Date filter week Mon-Sun

I agree. It would be nice to be able to set this value on a per PBIX file. Some teams may use the standard Sun-Sat cycle, but for project work, we use Mon-Sunday.

AND/OR

Allow there to be an option when using the "End of Week" transforming the column to be able to specify the start of week.

derek's profile image Profile Picture

Peter Nielsen on 10 Feb 2021 15:17:46

RE: Relative Date filter week Mon-Sun

Really need this!

Right now, if selecting "Last 20 Calendar Weeks", then it includes only "Sunday" from the first week, since I use another weeknum with Monday. This should be a mandatory feature!

derek's profile image Profile Picture

Phil Dennison on 09 Feb 2021 16:08:28

RE: Relative Date filter week Mon-Sun

Please tell me this is getting fixed? If not I may seriously need to consider using another BI tool :-(