Timezone issues between Power Bi desktop and service

[Anonymous]

Hi all,

I am having an issue with the timezone differences from service to desktop. I have a matrix which shows sales, budgets etc..

On the desktop I have created a measure called 'IsFuture' where I refer to the date in the Date table and determine whether it is future (=1) or is not (=0). I then apply this measure as a filter on the matrix to ensure it only shows data for the dates that are not in the future ('isfuture = 0). This works on desktop - but when publishing to service it doesnt include yesterdays results because of the service using UTC time instead. 

Also, I have a card visual representing yesterdays results, I have used a relative date filter where date is in the last 1 days (not including today) but suprisingly it is showing me results from 2 days ago which doesn't make much sense. E.g. todays current date for me is 8th Feb 2021, but the relative date is picking up 6th Feb 2021 as yesterday in the desktop .pbix

How can I fix these issues, I have seen many articles about using Power Query but unsure how to put them into practice because my date table is a CALCULATED TABLE not a query... 

[nickyvv · Accepted solution]

Hi @Anonymous,

Please have a look at Solving DAX Time Zone Issue in Power BI for example.

[Anonymous]

Thanks I was just able to use the TIME() function to add 11 hours to the IsFuture measure in DAX.

[lbendlin]

You can't really fix that if your users are sitting in different timezones. If for some reason they are all in the same timezone then you can follow the articles that force a time zone specific display based on text formatting.

[Anonymous]

My users are all in the same timezone UTC +11. Could you please suggest a method or articles of text formatting that will work?