Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Relative Dates - Start Monday

Hi

 

I really need to know how to set my relative start dates to a Monday.  My regional settings are set to UK whch starts Monday, but whenever I add a date into my report and set a relative filter it always sets the start date to a Sunday.  Its drivng me mad as most of my reports require a correct relative date.  Can anyone asssit?  New to Power BI, and this is such a frustration. Many thanks

Need Help

11 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    5 years ago

    Hi Anonymous ,

     

    What are the regional settings of the machine where Power BI is installed?

    Like I have "MONDAY" set at my end:

     

    Thanks,

    Pragati

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi

       

      Hi Pragati11, My regional settings are set the same as yours. I've got UK and first day is a Monday.  Even the server I use for the gateway has UK settings. Every report I create on any data wants to use Sunday as the first day? Thanks

      • Pragati11's avatar
        Pragati11
        Super User
        5 years ago

        Hi Anonymous ,

         

        Can you send me a screenshot for the relative filter where SUNDAY is the start day ?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi

     

    My regional settings are set the same as yours. I've got UK and first day is a Monday.  Even the server I use for the gateway has UK settings. Every report I create on any data wants to use Sunday as the first day? Thanks

    • aj1973's avatar
      aj1973
      Community Champion
      5 years ago

      Hi Anonymous 

      Open Power query and

      Verify where the server is and use Locale to your Date Column

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi aj1973, unfortunately this didnt work.  I'm still getting Sundayas my first day despite all settings being set to UK and first day Monday?  

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    5 years ago

    Anonymous 

    Can you check your regional settings in Power BI (under file/options and settings/options) that your "Current file" and "Global" regional settings are correct?

    Edit: Actually I just tried adding a relative date slicer for the last calendar week and I'm getting the same:

    So it looks like this is a bug.