Week Beginning changes to Sunday in the PBI service?

Power BI
1

**
Demo.pbix (282.7 KB)
Week Beginning changes to Sunday in the PBI service.docx (125.7 KB)
**

I am working with a slicer that slices by week.

I want to be able to see all the data by week. The weekly slicer contains Mondays and connects my date table to my data table.

The week beginning is designed to be Monday.

Calculating Start of Week

To create the week beginning column in my tables in power query I copy the date columns and then click Transform then date then select week then start of week.

What happens when I push the report to PBI service?

  • Initial push the report appears and works as designed in the PBI desktop
  • After first refresh the start of the week moves to Sunday.

How do I stop the week beginning shifting to Sunday?

2

Hello @jsavage,

Thank You for posting your query onto the Forum.

The reason why it might be causing the problem is because only function has been written i.e. “Date.StartOfWeek” but no reference or optional parameter is passed within it.

Try using -

each Date.StartOfWeek( [Date] , Day.Monday ), type date

image
image1010Ă—144 3.96 KB

Once the optional arguement is passed then I guess it should work smoothly.

I’m also attaching the working of the PBIX file as well as providing a link below of the documentation based on this function.

Hoping you find this useful and meets your requirements that you’ve been looking for. :slightly_smiling_face:

Thanks and Warm Regards,
Harsh

Demo - Harsh.pbix (290.9 KB)

1 Like
3

Hi @jsavage, we’ve noticed that no response has been received from you since a few days ago.

We just want to check if you still need further help with this post?

In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

4

Harsh this worked.

Thank you for the quick turnaround and clear explanation.

1 Like
5

Hello @jsavage,

You’re Welcome. :slightly_smiling_face:

I’m glad that I was able to assist you.

Thanks and Warm Regards,
Harsh

1 Like