Date format changes when publishing report

[Anonymous]

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? 

[AlexanderPrime]

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. 

[v-chenwuz-msft]

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.

[Greg_Deckler]

@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".