topic Re: Date Issue on chart in Report Server

Date Issue on chart

swanpaws — Tue, 23 Jul 2024 14:42:35 GMT

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:

Re: Date Issue on chart

Anonymous — Wed, 24 Jul 2024 02:12:25 GMT

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.

Re: Date Issue on chart

swanpaws — Thu, 25 Jul 2024 08:30:54 GMT

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!