Publishing to web, date change

[michael_knight]

Hi All,

When I upload my PBIX report to the web the date changes. Do anyone know why this happens and how to combat it happening in the future?

It's messing up the month by month numbers

This is the wrong. I'm only showing data from April 2019 onwards, but it's putting the numbers back by one date. This only happens when I upload it to the web

This is what it look like in Power BI

Regards,

Mike

[dax]

Hi michaelknight94,

When you design the chart, did you use slicer or filter to limit the date? Or use date function to limit the date? In addition, if you refresh the dataset and current report page in web, will it work well? And you also could delete the report from  web service and re-publish it to see whether it work or not.

Best Regards,
Zoe Zhi

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

[michael_knight]

Hi @dax 

I have one filter in the query editor that filters out null dates. The dates begin on the 1st of April so it should only show records from that period and beyond. 

I've tried refreshing the dataset, deleting it and uploading it but I'm getting the same results

Thanks