Skip to main content

Power BI

Needs Votes

Relative Date filter week Mon-Sun

Vote (1174) 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 (182)
derek's profile image Profile Picture

550c3b6f 12fd-4d80-891b-7afe08f9c17c 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

a5d602d8 6435-4f87-b639-5681f92606c9 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

3ce3d127 e3e5-4620-b754-4ce9490d397c 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

ad640843 b059-4e35-b213-b4ab8c9ed038 on 06 Jul 2020 00:13:57

RE: Relative Date filter week Mon-Sun

Just do it, MS ...

derek's profile image Profile Picture

e2763104 b3da-4c87-8806-91694bc564c2 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

234b7269 ef7e-4822-b53f-0afb852a5713 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

a7b65f16 1345-483c-a8b1-2339cf69d2f3 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

cb5b724b 10d8-4946-b1a0-1fb20ff8ce70 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

eda53b94 6a9f-4fa9-964d-7317466c5cc8 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

6d3b57b9 b51f-44ef-a1ec-4af795f1df2f on 06 Jul 2020 00:12:45

RE: Relative Date filter week Mon-Sun

Agreed, I endorse this request