Power BI Web - Report Parameter Datetime Picker format

[Anonymous]

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

[Anonymous]

As I pointed, the issue is the parameter section dattime format is wrong, not in the report body.

[Anonymous]

We are help using Power BI Report Builder.  Not Power BI Desktop.  

The above answer is not a  solution

[v-kkf-msft]

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,
Winniz

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

[Anonymous]

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.

[Anonymous]

This is not the solution.

The date format is wrong in parameter in the power bi web page.    Not in the report body.

[v-kkf-msft]

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,
Winniz

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