Date format

[Anonymous]

Hi all,

I have one report with different visuals for dates: baplot graph and filter. On the power bi desktop the format is equal for all the visuals: dd/mm/yyyy, nevertheless, once I publish the report into the Power BI sertvice, the format for the graph is still dd/mm/yyyy and the format on the filter is mm/dd/yyyy. The language on the desktop is English, the format on my computer is English and the language on the browser (Chrome) is also English.

How can I solve it?

[Anonymous · Accepted solution]

Hi @Anonymous 

Your want to show date value in DD/MM/YYYY format in slicer in Power BI Service.

The issue is caused by a combination of the settings in the Power BI Service and the settings in your browser. 

In this case, we are going to use chrome for the example.

By default, default English language in Chrome will use United States format (MM/DD/YYYY) to show dates in slicer.

Date format will be impacted by language region. So you will get result as MM/DD/YYYY instead of DD/MM/YYYY.

You can change language in Chrome as English(United Kingdom) to achieve your goal.

Don't forget to set the language setting in Power BI Service as (default browser language).

Restart your browser and date format in slicer will show in DD/MM/YYYY. 

Best Regards,

Rico Zhou

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