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

2ebb2e7d b7bb-4e91-83ae-261361e18719 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

5b2991de c5ef-465a-8004-c9c3fef7af1d 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

d7fce95f d0c4-ea11-a812-000d3a563be2 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

018c5326 3ddc-ea11-a813-000d3a579c38 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

b612e8a6 cfdb-ea11-a813-000d3a579c39 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

65f96b95 e5af-4d64-8061-01f5064ea662 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

2654cd36 a64d-47d7-81a4-11867fe8fc4d 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

derek's profile image Profile Picture

7f4fe1aa 4175-419b-bdef-58e8ba4edf39 on 10 Jul 2020 17:20:52

RE: Relative Date filter week Mon-Sun

We need this too

derek's profile image Profile Picture

69076047 7720-4c61-8e9e-50a19063068a on 10 Jul 2020 17:20:40

RE: Relative Date filter week Mon-Sun

'+1! Must have feature for business.

derek's profile image Profile Picture

0f826142 faed-4188-b5be-b5b9f1e3eaa2 on 10 Jul 2020 17:20:40

RE: Relative Date filter week Mon-Sun

plaese add this