Fix Releative Date Slicer / UTC issue.
I know I can change my data to be reflected in UTC but then i suddenly show, for example, Invoices paid Septmeber 30th as being paid in October. this is so wrong!
You simply need to change PBI where date slicers are reflecting local time and not UTC. I cannot display all of our financial data improperly (as UTC).
David Parsons commented
This is still a massive issue for us. Please fix it.
Setting the Power BI Service to local time is required. When connected to an SSAS live connection, a DAX formula can't be used as a work around.
I do not believe that the comment/formula below will work correctly in most circumstances.
"UTC Time = IF(hour(NOW()) < 11,[Date]-1,[Date])"
Reason being is the the relative dates for which to compare are calculated on the service before being compared to your data. For example, assuming UTC is ahead of your local time zone, the relative filter "Last Month (Calendar)" would prematurely flip over to looking at next month's data. The suggested formula approach could only fix the data for a particular relative time frame at best. This issue is exclusively on the service and can only be fixed by Microsoft. Truly, is a bug fix request and not a feature enhancement.
Please see the main idea that has the most votes so far:
ok, I did a work around to the bug by adding this column (I am in AEST daylight savings):
UTC Time = IF(hour(NOW()) < 11,[Date]-1,[Date])
And using this column to do the relative date slicer on.
are there any work arounds in the interim?
Yes, please fix!
This should be taken on priority.