Relative date slicer is including today only for external users

[jwest11]

Hi there,

This is my first post here, and I am a little new to Power BI, but have managed to solve 99% of the issues that I've come across since using the product. But this one has me absolutely stumped.

In a report I'm building, I have a table that lists meetings with the meeting name, contact name, and appointment date/time. I also have a relative date slicer on the appointment date/time that is tied to this. When I select Last 1 Day, I want that to show yesterday, so for that slicer I have the "Include Today" formatting option on the slicer (found under the Date Range format option group) toggled to OFF.

On PBI Desktop, it works as expected and shows yesterday's appointments when I select Last 1 Day. Furthermore, when I view the dashboard in PBI Service logged into my user, I can see it working as expected as well.

However, when the end user of this dashboard views the dashboard in PBI Service, selecting Last 1 Day shows only today's values (which is expected when the Include Today is toggled to ON).

This error has me stumped because it works on my end.  The user has refreshed the page, logged out and logged back in, I've pushed other changes to the dashboard since then that work on his end.

Please help!!

Thanks in advance!

[V-pazhen-msft · Accepted solution]

@jwest11 

The time on the Power bi service will be related to UTC. When the user uses the Power bi service to view this report, the time on the report will be displayed according to the UTC time zone the user is in.

For example:

When your time zone is 6 hours behind the standard time and your current time is 7 pm, then the standard time is 1 am the next day, Today() will return the data of the next day,

This is a link to related content, hope it will help you:

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

https://www.linkedin.com/pulse/power-bi-service-time-differences-how-fix-aaron-watsky

Best Regards,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

what timezone is the user in?