Forum Discussion
Power BI Web - Report Parameter Datetime Picker format
Updated:
We had to raise a ticket with Microsoft to ask them manually do a region fix.
This is clearly a bug on Microsoft Power BI.
==============================================================================
Original Question:
I have published a Report to Power BI web. The report Parameter Datetime Picker format is always MM/dd/yyyy , which I need to it to be dd/MM/yyyy.
I have changed Power BI web setting as Language = Default Browser language. I also changed my Firefox / Chrome language to English (UK) , but it did not change the Report Parameter Datetime Picker format.
Anyone has any idea how to fix this?
Thanks.
Firefox language setting for web pages
My FireFox settingwrong formatPower BI web setting
6 Replies
Hi Anonymous ,
The language in Service doesn't change the format of the date columns in the table. You need change the format from MM/dd/yyyy to dd/MM/yyyy in Power BI Desktop, and then republish to Service.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
WinnizIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Try the following formula in expression:
=Format(CDate(Fields!date.Value),"dd/MM/yyyy")If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
WinnizIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
