Dynamics 365 CommunityForums Microsoft Dynamics CRM forum Configure first day of...

Microsoft Dynamics CRM forum

Suggested answer

Configure first day of week for "relative date" filter on page or visual

(0) Share

Report

Report

Posted on by Community member

I'm building a report, which is based on calendar weeks. I'd like to filter data on some visuals to the last n calendar weeks. Unfortunately it seems as if those weeks are as ranging from sunday to saturday - which interferes with the measures and date dimesnion I've created (as my week starts on monday, data from the last sunday is not considered as it should ... just a tiny error, but still an error).

Is there a way to configure the definition of a week for page/visual filters? Alternatively: Is there a way to programmatically define a custom filter on the page/visual?

Any help is appreciated.

Thanks in advance.

Categories:

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report

Configure first day of week for "relative date" filter on page or visual

Hi Partner,

By default Sunday is considered the first day of the week, which affects system filters like “This week” and “last week”.

You can update it as following steps:

1.Go to Settings–>Administration:

2.Administration: > System settings:

3.Select the Formats tab, then Customize next to “Current Format”:

4.Under 'Date' tab:

I hope you can mark my answer verified if it answer your question! If you have any questions, please feel free to contact me.
Regards,
Leah

Helpful resources

Quick Links

Leaderboard

Andre Arnaud de Cal... 283,187 Super User

Martin Dráb 222,742 Super User

nmaenpaa 101,140

Featured topics

Product updates

Dynamics 365 release plans