Relative filter is picking up tomorrow

[michaelu1]

I created a relative filter to show my today and yesterday.

I just opened up my report at 11:19pm tonight and the relative filter shows tomorrow. ( I created a now measure to double check that PBI does indeed know that it is still 5/26 and not 5/27 yet.

Anyone know why?

[v-cazheng-msft]

Hi @michaelu1,

This issue should be caused by the time zone. According to the official document, the slicer and filter are always based on the time in UTC. So it calculates relative date based on UTC time and if you are in a different time zone, then you will see the same data with the users that in UTC time zone. For more details, you can refer to Use a relative date slicer or filter in Power BI - Power BI | Microsoft Docs.

Best Regards,

Community Support Team _ Caiyun

[michaelu1]

Thank you.

I read the article, it seems that this would be a common need for users using the relative filter.

Is there any documentation on:

• You can convert data captured in a local time zone to UTC using the Query Editor.

I'm not sure how to do that.

Also, the screenshot that I sent was on Desktop - not in the service, if that makes a difference.