Rolling average in graph suddenly stopped working in Power BI service

[oleverstat]

I have several reports that shows temperature data per month and 10 year rolling average.

See example:

https://app.powerbi.com/view?r=eyJrIjoiZmNlZDA0N2ItYmJjNy00ZjhjLWE2MmEtZjEzMjc2YzFlNTQwIiwidCI6IjZmM...

The 10 year rolling average has worked without problems for two years, but then it suddenly failed.

The calculation and visualization still works in Power BI desktop.

In Power BI desktop (10 year rolling avg in red):

Same report publised in Power BI service (10 year rolling avg fails, shows only one value - 1968):

What happened?

[oleverstat]

I have investigated the problem further.

The problem seems to be related to continuous x-axis and min/max dates + separating the rolling average by month (by the description field feature). Locking the x-axis by dates leads to just one date showing, and if I have no date lock the width changes from Power BI desktop to Power BI service report.

[v-xiaoyan-msft]

Hi @oleverstat ,

It seems a design issue,

If you would like to suggest  feature improvements, you may  vote the idea and comment here  to improve this feature. It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Best Regards,
Community Support Team _ Caitlyn

[oleverstat]

Hi @v-xiaoyan-msft ,

The stange thing is that these graphs have worked perfectly for two years published in PBI service, and the suddenly failed one day. So it seems to be a bug that appears when the report is prosessed in the PBI service.

Can it be that you have made changes to the how PBI handles x-axis dates in such graphs, and that this created the problem?

The rolling average graphs in red still works as before in PBI desktop.

Brgds,

Ole