Include Today not working in Relative Date

[rovers]

Hi,

I'm having problems with the relative date filter. It is currently 4 Sep  7.45 am in Singapore. When I use select "Include today" in the filter pane, 4 Sep is not appearing. Most of the time, this filter and report works fine, but occasionally like now, it is not working well. I have also added a card showing TODAY() is indeed 4 Sep. 

[v-yalanwu-msft · Accepted solution]

Hi, @rovers ;

As you said , the Power BI server’s date and time is based on UTC, and it might be different from your local timezone.

Methods are in high-level as below;

1. Use DAX expressions to add or deduct some hours from NOW()
2. Use Power Query functions to get the local time zone
3. Use a web query to get the local timezone from a Web API.

https://radacad.com/relative-date-slicer-for-your-local-time-zone-in-power-bi

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rovers]

However, at 8.15 am in Singapore, it is now working fine. This leads me to think that "Include today" is based on GMT timezone. Is this correct, and if so how do I overcome this problem?