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

(0) Share

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.

All responses (1)

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