Convert power bi report times by selecting different timezone

[Anonymous]

My users are in different timezone and need to access the report in their timezones.

Hence, I need all the times in the report to be converted to user timezone when a certain timezone is selected.

I am not able to figure out how to sync the time in the report tables with dynamic timezones filter.

please help me solve this.

Thanks.

[Anonymous]

Hi @Anonymous ,

You could create a table that contains time zone and corresponding time difference. Use the time zone as slicer and create a measure as below to add the time difference to times in the report.

Measure = SELECTEDVALUE('Table'[date time])+selectedvalue(slicer[timedifference])/24

Best Regards,

Jay

[lbendlin]

Create your report with UTC dates and then let the Power BI Service do the rest - it will convert all dates to the local timezone of the user looking at the report.