Forum Discussion

Globus's avatar
Globus
New Member
5 years ago
Solved

Relative Date filter - this week

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?

Show and Tell
  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    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.

2 Replies