Forum Discussion

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

 

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

General Comment
Need Help
Show and Tell
Tutorial Requests

2 Replies

  • dax's avatar
    dax
    Icon for Community Support rankCommunity Support
    6 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
      6 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