Hour of Day Line and clustered column chart changes when published to web service

[Seantb]

Hi all, 

I have a problem with a line and clustered column chart i created based on outlook email data showing the number of emails received by hour of the day. Although it shows correctly when viewing the graph in Power BI desktop, it changes as soon as i publish it to the web service and the bars show incorrectly. 

When in Desktop

When published to web service

I'm assuming this has to do with the time zone that is used in the service compared to when in desktop using the local time zone. I have not been able to find a work around or fix for this, can you please advise if you have any ideas to correct this?

[ribisht17 · Accepted solution]

@Seantb 

Please check this Solving DAX Time Zone Issue in Power BI - RADACAD

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users 

[Anonymous · Accepted solution]

Hi @Seantb ,

You can use DateTimeZone.SwitchZone function to get your offset date time in Query Editor.

DateTimeZone.SwitchZone(DateTime.AddZone([DateKey], 0),+2 ,0)

For example following steps in the picture below.

Enter into Query Editor, Transform -> Date/Time/TimeZone. For example like picture below:

More information: 

Convert UTC to client time zones? 

solving DAX Time Zone Issue in Power BI 

Best Regards

Community Support Team _ Polly

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

[ribisht17 · Accepted solution]

@Seantb 

Please check this Solving DAX Time Zone Issue in Power BI - RADACAD

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users 

[Seantb]

Thanks @ribisht17 , got this working. 

[Seantb]

Hi @ribisht17 , 

Thanks for sending me the link. I've followed the steps for the API in the below link, which uses the same site as your link. I've followed the steps to the end, but I'm not sure how to apply the timezone offset to my hour of the day data. 

https://whitepages.tygraph.com/2020/10/dynamic-time-zone-conversion-using-power-bi/

Can you advise what the next step would be?