Skip to main content
Microsoft Idea

Power BI

Under Review

Relative Date filter week Mon-Sun

Vote (2314) 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 (328)
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

derek's profile image Profile Picture

Marinos Skarmeas on 06 Jul 2020 00:13:21

RE: Relative Date filter week Mon-Sun

We really need this feature. Mon-Sun weekly reporting is the practice for many companies. The current structure of Sun-Sat is not of help.

derek's profile image Profile Picture

Lutijn de Kruijff on 06 Jul 2020 00:12:55

RE: Relative Date filter week Mon-Sun

This could really be helpful

derek's profile image Profile Picture

F Boerma on 06 Jul 2020 00:12:45

RE: Relative Date filter week Mon-Sun

Agreed, I endorse this request

derek's profile image Profile Picture

Power BI User on 06 Jul 2020 00:12:26

RE: Relative Date filter week Mon-Sun

Please ! I need this feature...

derek's profile image Profile Picture

Jase on 06 Jul 2020 00:12:21

RE: Relative Date filter week Mon-Sun

This is really affecting our reporting, we need weeks to start on a Monday. 974 votes and still no sign of this is in Microsoft's plans.

derek's profile image Profile Picture

Bart on 06 Jul 2020 00:12:21

RE: Relative Date filter week Mon-Sun

Hello MS, WAKE UP
I'am already 5 years with Power BI, an awesome tool!
But this is really a shame, missing this option!!!

derek's profile image Profile Picture

Heidi Power BI User on 06 Jul 2020 00:12:20

RE: Relative Date filter week Mon-Sun

This is a must have.