Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Relative Date Filtering is offset even in Power BI Desktop

Submitted by Anonymous on ‎09-03-2018 04:46 PM

I noticed my reports that were using relative date filtering were treating "Today" as the 3rd of September, when in local time its the 4th of september.  This is presently 9:40 AM AEST time (GMT +10 no daylight savings).

 

At first I thought this might be a case of the Service treating itself as being the localtime UTC, however when opening the project in Power BI desktop, where my local time shows on my clock, the relative dates are still offset.

 

Capture.PNG

 

Power BI Version

 Version.PNG

Status: Accepted
See more ideas labeled with:
22 Comments (22 New)
Comments
Anonymous
Not applicable
‎11-12-2019 04:56 PM

vote up here https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/33851443-specify-timezone-for-rel...

HVenter
Frequent Visitor
‎01-05-2021 03:37 PM

This thread was started in 2018. We're now in 2021 and this is still an issue - I'm using PBI Desktop Version: 2.87.762.0 64-bit (November 2020). This should be labelled as a bug (and should include the Power BI Service as well)? The relative date/time filtering across all components of Power BI is useless for anyone NOT in UTC time.

Idea Statuses