Forum Discussion
Date format changes when publishing report
Hi all,
So I've seen similar questions asked on the forums but none that are the same as mine.
In a report i have the date set like so
However when published the same report has the data set like:
As you can see the day name appears evn though with the powerbi report the date format is set to dd mmmm yyyy.
Does anyone know why this is happening and how to prevent it?
3 Replies
https://community.powerbi.com/t5/Desktop/Date-format-changing-desktop-to-web/m-p/141538#M60993
This worked for me, it's a combo of language settings you need to change. Short of it is, change your browser language within the browser itself to your region (assuming English UK), then in Power BI Web's language setting, don't select English, select "DEFAULT - Browser Language" and it should get the date format back to normal on web.Anonymous You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".Hi Anonymous ,
If the date you want to fixed the format, you can use FORMAT().
FORMAT function (DAX) - DAX | Microsoft Docs
Try new column like the following:
New Date = FORMAT( [DATE], "dd mmmm yyyy")Keep in mind that the result is string.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
