Date format in exported PDFs different from Report UI (desktop and web)

[rafoztr]

Hi PBI community.

My PBI reports need to show dates in the Australian format, dd/mm/yyyy.  In Power BI Desktop or when viewed from the workspace on the PBI service the slicers show dates in that format.  However, when those same reports are exported to PDF (or PowerPoint), the dates shown in the slicers are shown in the US format (mm/dd/yyyy).  Below are the slicers as shown in the service:

...and the same slicers in the exported PDF:

What makes it more strange is that other fields that show dates in the report do not behave like that...  It seems to affect slicers only.  Additionally, this issue does not happen for other PBI developers in my organisation, only me.  I wonder if that is caused by some setting in my PBI/Azure account?

Any suggestions on what I should check would be greatly appreciated.  Thank you!

[ShanS]

Hi guys,

Is there a solution to this yet?

Cheers

[sasok]

Hi @rafoztr ! I'm experiencing the same issue. 😞 Have you been able to find a solution?

[rafoztr]

hi sasok,

Unfortunately, no. We tried all the ideas suggested by MS support but nothing worked.  One day, out of nowhere, the issue was gone and it remains working correctly to this day...

In case this is useful to you, this was the list of checks suggested by Microsoft support:

"1. Windows setting – please make sure you have these settings set to “English (Australia)” or “Australia”

2. Browser setting:

• In your browser (Chrome), open “Setting” and select “Language” under “Advanced”.
• Expand “Language”
• If you didn’t see “English (Australia)”, please add
• Click on the three dots next to “English (Australia)” and tick “Display Google Chrome in the this language”
• Click “Relaunc

3. Open Power BI Service

• Click on the “Wheel” icon and select “Settings”
• Click “Language” and make sure it sets “Default (browser language)”
• Click “Apply”

Once you have all set, if you change your Windows setting, probably it’s a good idea to reboot and try to open the report again."

[sasok]

Hi rafoztr,

Thank you for the detailed instructions.

I've tried exactly the same steps - in my case it is unfortunatelly still not working.

I guess I'll just have to live with that. 😞

Best regards,

Sašo

[v-jayw-msft]

Hi @rafoztr ,

This situation is generally caused by different regional settings on Power BI Service and Power BI Desktop.

https://docs.microsoft.com/en-us/power-bi/fundamentals/supported-languages-countries-regions#choose-... 

You could also check the regional settings for the bowser and your system.

Best Regards,

Jay

[rafoztr]

The issue continues.  We have engaged with Microsoft Support and tried the steps below:

1. Reviewed language, regional, and date format setting in Windows, web browser, and Power BI Service and everything looks fine
2. Tested the export to PDF from Power BI desktop and PBI Service, but the date format still shown in US format.
3. Recreated the slicer and tested. The export to PDF worked in Power BI Desktop (the PDF was in the desired Australian format). When the report published  to PBI Services, the export to PDF still shown date in US format.

Once we get to the bottom of this, I'll post an update to this thread.