Forum Discussion
Date picker doesn't respect locale settings
In the Date picker a relative calendar week is always from Sunday to Saturday.
In European cultures (e.g. French) it should be Monday to Sunday.
8 Replies
v-saisrao-msftCommunity Support
HI katsarr,
Have you had a chance to review the solution shared by tayloramy GilbertQ? If the issue persists, feel free to reply so we can help further.
Thank you.
- tayloramy
Super User
Hi katsarr,
That's a fun bug.
I recommend opening a ticket to Microsoft about this so that the support engineers can log it internally.
If you have a pro license, you can submit a ticket here:
https://support.fabric.microsoft.com/support/
When I open the date picker, the first day of week is Monday (e.g. 10-August). But when I set a filter for relative calendar weeks it filters a week that starts with Sunday (9-15 August). I reported a bug.
- maruthisp
Hikatsarr,
I faced the similar issue. Date filler on the visual always check for UTC timezone.
To avoid, there are couple of ways as below:- Create a DATE dimension with French time zone based columns like Calendar Week Start Day and Calendar Week End Day, any language translations, Time Zone offsets, Day Light Savings etc.,
- Create a flag as column that can True or False that can use as filter on the visual.
Best Regards,
Maruthi
We have it this way. It means that the user can't select custom dates before the last week. So to do that there is a button with a bookmark to remove that flag filter from the slicer... I wanted to replace all of that with the new date picker
