Skip to main content
Microsoft Idea

Power BI

Under Review

Relative Date filter week Mon-Sun

Vote (2304) 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

CeciliaR on 06 Jul 2020 00:16:53

RE: Relative Date filter week Mon-Sun

This should be done asap, unbelievable it hasn't been done already.

derek's profile image Profile Picture

Rafael Ribeiro on 06 Jul 2020 00:16:43

RE: Relative Date filter week Mon-Sun

This is so US-centric... whoever starts their week on a Sunday?!

derek's profile image Profile Picture

Power BI User on 06 Jul 2020 00:15:54

RE: Relative Date filter week Mon-Sun

This is a must have feature. If the user chooses another day than the first in week, then 2 weeks are not valid to use, and we have a splendid opportunity with the Week Mon- Sun. In Denmark hardly anyone starts on a sunday as reporting Week.

derek's profile image Profile Picture

Peter Podsklan on 06 Jul 2020 00:15:32

RE: Relative Date filter week Mon-Sun

Almost 3 years and >1k votes later and still not added? I am one of those who'd much appreciate this small added feature. Thanks!

derek's profile image Profile Picture

H. Pahnke on 06 Jul 2020 00:14:55

RE: Relative Date filter week Mon-Sun

Just do it, MS, we in Germany need this function!!!!!

derek's profile image Profile Picture

James Hanson on 06 Jul 2020 00:13:57

RE: Relative Date filter week Mon-Sun

3 years in the waiting.

derek's profile image Profile Picture

Power BI User on 06 Jul 2020 00:13:57

RE: Relative Date filter week Mon-Sun

Just do it, MS ...

derek's profile image Profile Picture

Eric Iverson on 06 Jul 2020 00:13:54

RE: Relative Date filter week Mon-Sun

I agree, this should be a basic setting. Our company runs on a Saturday–Friday week, why can we assign that in other MS products but not Power BI?

derek's profile image Profile Picture

Gartxot Koblakaria on 06 Jul 2020 00:13:36

RE: Relative Date filter week Mon-Sun

I really don't understand why this is not included yet. Don't you know that Monday-Sunday is the most common week all around the world?

derek's profile image Profile Picture

jon bell on 06 Jul 2020 00:13:26

RE: Relative Date filter week Mon-Sun

this needs to be improved, i have just created a report and used the WEEKNUM function in to add the week number to my date table, but used this formula WEEKNUM([Date],2) now my chart with the weeknum as the axis does not match the data in any charts with the relative date filter applied.

the rest of the relative date filter is amazing though