Forum Discussion

michael_knight's avatar
michael_knight
Icon for Post Prodigy rankPost Prodigy
7 years ago

Publishing to web, date change

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   ...
General Comment
Need Help
Show and Tell
Tutorial Requests
dax's avatar
dax
Icon for Community Support rankCommunity Support
7 years ago

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's avatar
    michael_knight
    Icon for Post Prodigy rankPost Prodigy
    7 years ago

    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