Forum Discussion
Help with Power Query Date Table returning Error for some columns
I believe I have fixed the issue by having a play with the day offset filters and seems to be working as it should. Thanks for your time and help.
Vijay_A_Verma wdx223_Daniel are you able to assist please?
Hi Anonymous ，
Relative date filtering in Power BI Service defaults to UTC time zone, and we cannot change the time zone at this time.
This script does not allow us to use the relative date filters correctly, rather it creates several Offset Date slicers to achieve the same result as the relative date slicers. That is, you need to use [Day Offset] for filtering.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-kkf-msft sorry for the delayed reponse but I think it may have fixed the issue as I forgot to include another condition for the OFFSET filters i.e. "and is less than or equal to 0". I will need to confirm tomorrow my timezone (NZST -12hrs) and its past midday here so I'll wait until tomorrow morning to confirm if offset filter is working correctly.
v-kkf-msft my published report on PBi service is not showing correct date i.e. the Offset filters are not working as they should. They are still on UTC time. At the time of writing this message, my timezone is NZST July 19 09:00am but the date filter is showing data for July 18.
I private messaged you the pbix file for reference if you need.
Appreciate your help on how to resolve this please as I've tried and tested many suggestions but can't get it to work.Hi Anonymous ,
Have you refreshed the dataset on the new day? I suspect it may be because the data has not been updated.
Best Regards,
Winniz