Relative Dates - Start Monday

[Anonymous]

Hi

I really need to know how to set my relative start dates to a Monday.  My regional settings are set to UK whch starts Monday, but whenever I add a date into my report and set a relative filter it always sets the start date to a Sunday.  Its drivng me mad as most of my reports require a correct relative date.  Can anyone asssit?  New to Power BI, and this is such a frustration. Many thanks

[Daweiwang]

Hi!

I was confused by it as well, and I just found a way out. Check it out below:

https://community.powerbi.com/t5/Community-Blog/Relative-Date-Dimension/ba-p/779039

[PaulDBrown]

@Anonymous 

Can you check your regional settings in Power BI (under file/options and settings/options) that your "Current file" and "Global" regional settings are correct?

Edit: Actually I just tried adding a relative date slicer for the last calendar week and I'm getting the same:

So it looks like this is a bug.

[PaulDBrown]

@Anonymous 

I've reported it in the "Issues" forum (fingers crossed):

https://community.powerbi.com/t5/Issues/There-is-a-bug-in-the-relative-date-slicer-incorrect-calendar/idi-p/1651800#M64209 

[Anonymous]

Great, so i'm not ging crazy then 😁.   Yes all setting are UK.  Thanks for you help!

[PaulDBrown]

@Anonymous 

please click on the link to the issues forum and "vote"! (need to make a bit of noise to get some attention...!)

[Anonymous]

Hi

My regional settings are set the same as yours. I've got UK and first day is a Monday.  Even the server I use for the gateway has UK settings. Every report I create on any data wants to use Sunday as the first day? Thanks

[aj1973]

Hi @Anonymous 

Open Power query and

Verify where the server is and use Locale to your Date Column

[Anonymous]

Hi aj1973, unfortunately this didnt work.  I'm still getting Sundayas my first day despite all settings being set to UK and first day Monday?  

[Pragati11]

Hi @Anonymous ,

What are the regional settings of the machine where Power BI is installed?

Like I have "MONDAY" set at my end:

Thanks,

Pragati

[Anonymous]

Hi

Hi Pragati11, My regional settings are set the same as yours. I've got UK and first day is a Monday.  Even the server I use for the gateway has UK settings. Every report I create on any data wants to use Sunday as the first day? Thanks

[Pragati11]

Hi @Anonymous ,

Can you send me a screenshot for the relative filter where SUNDAY is the start day ?