How to apply UK date format (dd/mm/yyyy) in Date slicer?

[Dhruvin]

I have a client from UK.

My client needs date in the slicer in form of "dd/mm/yyyy" format.

I checked the Power BI OOTB date format. There is no option for "dd/mm/yyyy" = 15/12/2018

Also, even if we change date format, slicer does't take effect of newly created format.

How to achieve this requirement?

I have already fried following steps:

Change Regional settings:

Change the Locale in Advanced Editor.

Still date format in date picker not changed.

The Sample Data Source file and Power BI File - Download Here.

[itsme007]

Hi,

I am experiencing this same issue, PC region settings set to UK PowerBI Global region settings set to UK and this file regional settings set to UK, i have even been in and changed the column format "change type with locale" to UK, the report shows fine on the desktop but as soon as i upload it and try to view it the slicer is in American format once again.??

[Dhruvin]

@v-lili6-msft: When I publish the report the changes are not reflected in Power BI service, but it works in Power BI Desktop.

[v-lili6-msft · Accepted solution]

hi, @Dhruvin

Based on my test, the date format of date slicer is based on local computer region setting.

For example:

In your pbix file.

so you may try to change the region setting for the computer.

Best Regards,

Lin

[Dhruvin]

Yes, You are right!

Thanks

[reza_rad]

You can change the Locale to UK in the Power BI Desktop file ->options and settings -> Options ->In the current file -> Regional Setting

[Dhruvin]

@reza_rad Sir - Thanks a lot.

I have tried this.

After that I also changed type of the date using Locale in advanced editor.

Still my DatePicker not taking effect of UK date format. UK date format is dd/mm/yyyy

I also attached sample Power BI file here: Download:

Any help really appriciated!

Thanks a lot 

[Dhruvin]

That doesn't work.
Slicer still showing data in mm dd yyyy format.