Changing first working day of the week in slicer without DAX

[SErgey-kuznetso]

Hi,

How can I change format of the week in slicer. I want to use relative date (calendar week ) but i'm from Russia and our week starts on monday.

Excample:

here the week starts from 26.07.2020 and ends with 01.08.2020, but for me it is necessary to starts from 27.07.2020 and ends with 02.08.2020.

Thanks in advance!

[v-diye-msft]

Hi @SErgey-kuznetso 

If the above post helps, please kindly mark it as answer to help others find it more quickly. thanks!

[tex628]

The relative calendar week filter is sadly bound to sun->sat. You can do a workaround by creating a new column in your date table moving the entire date column one day backwards. By using this column in the filter instead the sun->sat filter will effectivly become a mon->sun filter instead. 

/ J

[az38 · Accepted solution]

@SErgey-kuznetso 

work with russian regional settings is always a challenge in Power BI

for your case, @tex628 suggested maybe the only option I know is to create a new column like

Slicer Date = Table[Date] + 1

[amitchandak]

@SErgey-kuznetso , I doubt that there is no option as of now.

But regional setting may help

You can try with changing the Regional Settings. My Locale is <> and the week starts from Monday to Sunday.

Go to: File -> Options and settings -> Regional Settings