Forum Discussion

swanpaws's avatar
swanpaws
Frequent Visitor
2 years ago
Solved

Date Issue on chart

Hi. I have a chart with a date which looks fine in Powerbi but as soon as I publish a report, the dates all splay out into random months which aren't even in the date field. The actual month_year col...
Date
  • swanpaws's avatar
    swanpaws
    2 years ago

    Thanks for your reply on this. I've had a look and using a table visual have noticed that the day and month switch round when published which is why it was splaying out. i.e. 05/02 becomes 02/05. I've played about with DAX and managed to get it working now. Thanks for your help!

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi swanpaws ,

You have the x-axis date from August 23 to July 24 on the desktop, but on the service you can see that it goes directly from January 23 to December 24.

First of all, is there any data update in between, such as adding new data or refreshing the dataset?

Because I see that after posting to the service, not only the date of the x-axis has changed, but the entire data has changed as well, and this may be a refresh of the entire data set.You can examine the data.

If you can't find a solution after checking the data, could you please provide me with the pbix file and I'll run a test to identify the exact cause?

Best Regards,

Xianda Tang

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

  • swanpaws's avatar
    swanpaws
    Frequent Visitor
    2 years ago

    Thanks for your reply on this. I've had a look and using a table visual have noticed that the day and month switch round when published which is why it was splaying out. i.e. 05/02 becomes 02/05. I've played about with DAX and managed to get it working now. Thanks for your help!