cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Elisa_A
Frequent Visitor

See the dashboard in the local time in each time zone

Hello,

I have a dashboard with an histogram wich has last 7 days on the x-axis. This dashboard is published in own website, through Power Embedded. The question is: would each costumer see the report in his local time?

e.g. in Italy it's 08:00 PM of 10 May and in Sydney it's 04:00 AM of 11 May: in the histogram, would the user in Italy see the days between 4 and 10 of May and the user in Sydney see the days between 5 and 11 of May?

Which action I must take in order to guarantee the correct visualization for each time zone?

Thanks,

Elisa

4 REPLIES 4
Community Support
Community Support

Re: See the dashboard in the local time in each time zone

Hi @Elisa_A,

 

Current the time zone in the power bi service is effectively always set to UTC, it not support auto transform by ip. (It is a feature which still in develop)

Reference:

Time in PBI Service is inconsistent with the local time (non-UTC time) displayed in PBI Desktop  

 

I'd like to suggest you submit the requirement to "ideas" forum.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Elisa_A
Frequent Visitor

Re: See the dashboard in the local time in each time zone

Thanks for your answer.

Actually, I referred to the Embedded Service and not to the Power BI Service. So, how could I apply the suggestion of the link to my case? Thanks,

Elisa

Community Support
Community Support

Re: See the dashboard in the local time in each time zone

Hi @Elisa_A,

 

It told that use power query "DateTimeZone.SwitchZone" function to convert the default time to specify timezone. (Add custom column, use "DateTimeZone.SwitchZone" in design panel)

 

BTW, above function can transfer datetime to specific timezone, but it not support to dynamic convert datetime to local.

 

Regards,

Xiaoxin Sheng

 

 

Community Support Team _ Xiaoxin
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Ballwood81
Regular Visitor

Re: See the dashboard in the local time in each time zone

Yeah this issue is killing me too.

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors