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 column is a string field which is formatted from a date column and ranked by a separate YYMM column. Can't figure out why I'm getting this display issue - is it a powerbi bug? Any help would be greatly appreciated. 

 

Thanks, 

 

In BI desktop:

 

 

In Bi when published:

 

 

Data:

 

 

 

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!

2 Replies

  • 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!