How to handle relative date slicer in Power BI Service? UTC timezone issue

[average_student]

Looking for ideas on how people solved the time zone issue between Power BI Desktop and Power BI Service.  I'm in EST so when I'm building a report it reflects EST time zone, but then when I publish the report it reflects UTC time.   Please let me know how you solved this for the relative date slicer? Question is how can you make sure this slicer performs the same in the power bi service.

Using Direct Query and My date field used in the relative date filter is already in EST. 

For example, on 19th Jan 2022 at 8pm for EST, the relative date switches to the next day(20th Jan) because its midnight UTC time. So if you select "This day" after 8pm-11:59pm EST in the service, the relative date slicer shows tomorrow's date(20th Jan as per UTC), while it should be showing 19th Jan 2022.

[lbendlin]

Please read this https://radacad.com/solving-dax-time-zone-issue-in-power-bi 

[average_student]

Hi, 

Thanks for your response. While the solutions in the article help me to convert the data from one timezone to another, the problem i am facing is with the relative date filter of PowerBI.

My data is already corrected to the timezone while querying in sql and i am using the timezone adjusted date column as the filter.

If I go with the slider as a way to filter the report then i dont have any issues.

But when i choose the relative date type as the filter, it is always referring to UTC time. Like when the time is 2022-Jan-21 01:00 AM in UTC, "This day" option of relative date switches to 21st even though it's still 2022-Jan-20 08:00 PM in EST. Since the date filed is timezone adjusted it has data only till 2022-Jan-20 08:00 PM.

My doubt is how to make the relative date filter use the local time instead of the UTC time?

[marcopol]

Apparently, it's not possible. I have the same problem, I read that you can create a combination of slicers which is not what I want, I want to use the date slicer but you know Microsoft being Microsoft.