Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
Hi!
I was confused by it as well, and I just found a way out. Check it out below:
https://community.powerbi.com/t5/Community-Blog/Relative-Date-Dimension/ba-p/779039
@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.
Proud to be a Super User!
Paul on Linkedin.
@Anonymous
I've reported it in the "Issues" forum (fingers crossed):
Proud to be a Super User!
Paul on Linkedin.
Great, so i'm not ging crazy then 😁. Yes all setting are UK. Thanks for you help!
@Anonymous
please click on the link to the issues forum and "vote"! (need to make a bit of noise to get some attention...!)
Proud to be a Super User!
Paul on Linkedin.
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
Hi @Anonymous
Open Power query and
Verify where the server is and use Locale to your Date Column
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
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?
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
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
Hi @Anonymous ,
Can you send me a screenshot for the relative filter where SUNDAY is the start day ?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
145 | |
87 | |
66 | |
51 | |
45 |
User | Count |
---|---|
215 | |
90 | |
83 | |
66 | |
58 |