Relative Date filter - this week

[Globus]

Hi,

Setting the "Relative Date" filter at the Visual level to "This Week" does not work correctly. It is not possible to change the schedule of the week from English Sunday - Saturday to our Monday - Sunday. I tried setting the locale and unfortunately I couldn't change it. Does anyone know any help on how to do this?

[v-robertq-msft · Accepted solution]

Hi, @Globus 

According to your description, it seems that you are facing the problem that you can’t change the schedule of the week in the “Relative Date” filter, I think the first way to can try is to change the regional setting of the computer and the Power BI desktop to check if it can work:

If it can’t work, you can try to use the WEEKNUM() function in DAX to create a measure to achieve the same filter as this:

Flag =

IF ( WEEKNUM ( MAX ( [Date] ), 1 ) = WEEKNUM ( TODAY (), 1 ), 1, 0 )

Then set the visual filter like this:

And you can also get what you want.

More info about the WEEKNUM() function in DAX

You can download my test pbix file below

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Globus , refer to this solution from past

https://community.powerbi.com/t5/Desktop/how-to-change-calendar-week-start-date-from-Sun-to-Mon/m-p/...