Set week start on Monday to Sunday in a filter Slicer

[TomasBajuk]

Hi Community,

I'm using a Relative Date Filter in a Dashboard.

My problem is that Power BI automatically recognizes Sunday as the first day of the week. I need to set Monday as the first day.

Also, when I use the service, does it depend on the browser's regional settings, or can I set it to always start on Monday?

Thank you!

[SamWiseOwl]

Hi @TomasBajuk 

Sadly the option to have this able to change to Monday has been requested since 2017 and is still "Under Review":
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=c0261391-c1c1-4452-ac59-2cf8c6a09983

If I am worng please please someone correct me, I also want this feature.

The only option is to create your own calendar table to do the same thing, something like this:
https://community.fabric.microsoft.com/t5/Desktop/Required-custom-date-Slicer-Last-7-days-last-15-da...

Power BI date formats in other regards are by default based on the use browser, this is an excellent blog showing how to change each browsers dates, sadly it wont help with the first issue:
https://www.mssqltips.com/sqlservertip/6834/power-bi-service-date-formats/

Please mark as a solution for others to find if this works 🙂