BUG: All date slicers changed format to US(mm/dd/yyyy)

[Spegkas]

All date slicers changed format to US(mm/dd/yyyy) , while all date fields are set to short date dd/mm/yyyy.
This happens using any regional settings on pc or browser and we noticed it in the last 1,5 week.
This happens only on service, in power bi desktop it has the expected behaviour.

[Anonymous]

Hi  @Spegkas ,

I tried to do a simple test but it doesn't seem to reproduce the problem, any more information would be great.

What is the version you are using? please tell us which browser is being used.

Best regards.
Community Support Team_Caitlyn

[Spegkas]

Hello @Anonymous ,
Thank you for your reply.
Do you have access to archived support issues? If yes, this is my case:
• Service Request #: 2312140050002532
• Service Request Title: Date slicers on existing reports changed format to mm/dd/yyyy on service while short date dd/mm/yyyy is selected
• Closed Date: 12/14/2023 2:12:42 PM UTC
And this is the summary of the call with the microsoft support:
"Summary:
-Thank you for contacting Microsoft support it was my pleasure to assist you.
-As per verbatim, we have understood that your facing the issue in slicer date format while publishing it from desktop to service.
-Listing out the points which we have discussed.
-we have suggested to change the power bi default language setting and it worked.
-we have suggested to change the format in local machine and it didn't work.
-suggested cx to change the format in regional settings of the power bi and it didn't work either.
-suggested to create a new report with date slicer in the desktop, published it service and there's an incorrect date format in the slicer.
-We have informed you that there's an ongoing issue on the date format and our Engineering team is working to fix that."

[Spegkas]

If you want to reproduce the problem, try this:
- Create a test report in power bi desktop with one table with only dates and add a slicer for dates and a card with the date field . Make this field format as short "dd/mm/yyyy". Everything should work as it should and both slicer and card display dates as "dd/mm/yyyy".
-Then publish the report and now the dates on slicer will change to US format "mm/dd/yyyy". The work around is to change the ui language on service to greek, but this is not how it should work because when you chose the short date without the asterisk, you always force the format to be what you want, no matter what locale settings are on browser or service or operational system .