Cumulative chart not rendering correctly after refresh.

[tomringer]

Hi,

I am having an issue with some cumulative/ period to date measures. They appear how i want them on teh desktop version and, untill I installed a gateway to refresh daily, rendered correctly on pbI.com. However since installing the gateway the current year has gone awry. The only thing I can think of is that it's something to do with the date format being different on desktop or online. Any ideas? Here is the measure I am using

MTD Sales Cumulative = CALCULATE(SUM(Append1[LineTotalValueBase]),Filter(ALLSELECTED(Append1),'Append1'[Year] = MAX('Append1'[Year]) && 'Append1'[OrderDate]<=Max('Append1'[OrderDate])))

Thanks, Tom

[v-qiuyu-msft]

Hi @tomringer,

Please refresh the report in Power BI desktop to see if the chart display well.

In Power BI service, the time zone is UTC. Please check your data to see if the issue related to time zone gap between Power BI desktop and service. See: Time in PBI Service is inconsistent with the local time (non-UTC time) displayed in PBI Desktop.

Best Regards,
Qiuyun Yu 

[tomringer · Accepted solution]

Thanks for getting back to me Qiuyun Yu.

I have solved the issue, which wasn't connected to the date/ time format after all. I was pulling the data through from two different sources - one a static historical worksheet and the other from a live sage query. It turns out a sage developer had changed the format of the value field from whole decimal to $ meaning I wasn't joing, and subsequently summing teh same data types. It's all good now though

Best wishes,

Tom