Date format in slicer is changing to mm/dd/yyyy when published to service

[bml123]

HI,

I have a report with date slicer and I have formatted it to dd/mm/yyyy and is working fine in PBI desktop. But when I published the report to service, the format in the date slicer is changing to mm/dd/yyyy.  I have checked the language settings in my browser and it' already set to English UK. Any idea?

[mussaenda]

Hi @bml123 ,

it happens when the date format you chose on the desktop has the (*). It takes whatever is the format of your browser when the report was published. If your broswer language is EN US then it will be mm/dd/yyyy.

Then if it is changed the broswer language to EN UK it will be dd/mm/yyyy. 

To avoid this, try choosing the date format you want on the desktop without the (*)

Hope this helps

[v-xiaotang]

Hi @bml123 

Have you solved this problem? If yes, could you kindly accept the answer helpful as the solution to help others find answer faster? 

Really appreciate!
Any question, please let me know. Looking forward to receiving your reply.

Best Regards,
Community Support Team _Tang

[v-xiaotang]

Hi @bml123 

sorry for the late reply. 

1. change the settings in Desktop

2. make sure that English(UK) is default language in your browser.

3. change the language settings in Service 

Best Regards,

Community Support Team _Tang

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

[ibarrau]

Hi. I was going to suggest changing the data type to "Using regional". There is a change of type in Transform Data menu to change to an specific region. You can pick date -> UK. However I have run into this post that is suggesting something else. You can check it, it's showing both the two options:
https://community.powerbi.com/t5/Desktop/How-to-apply-UK-date-format-dd-mm-yyyy-in-Date-slicer/m-p/5...

I hope that helps,