Forum Discussion

kellyyaker's avatar
kellyyaker
Frequent Visitor
5 years ago
Solved

Graph Display Changes from PBI Desktop to Shared Report in App

I am having trouble with a graph showing one graph result in my desktop instance and another in the online version. I know it has something to do with the date, as the # leads that shift from January...
Need Help
nickyvv's avatar
nickyvv
Most Valuable Professional
5 years ago

Hi kellyyaker,

the first thing I thought of when you mentioned the month-end, was the different timezone the PBI Service (and thus your report) is in. That's always in UTC, unless you tell it otherwise.

Reza Rad has a very good blog post about this topic of Solving DAX Time Zone Issue in Power BI, but you can also do it in M with the timezone part of the datetime datatype.

kellyyaker's avatar
kellyyaker
Frequent Visitor
5 years ago

This is a really helpful blog post, but if the date I'm using doesn't have any exact timestamp on it, just the date, can timezone affect the date itself?

Here are the related fields being used in the table:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

To be clear, I'm not using any DAX to calculate the date used in the report. The query for the invoked function date uses date and not time.