cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Dhruvin Member
Member

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

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:

11.png

Change the Locale in Advanced Editor.

12.png

 

Still date format in date picker not changed.

13.png

 

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

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

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.

10.JPG

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

 

Best Regards,

Lin

 

 

 

 

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 REPLIES 6
reza_rad Regular Visitor
Regular Visitor

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

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

2019-01-14_15h53_11.png

Dhruvin Member
Member

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

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

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

@reza_rad Sir - Thanks a lot.

 

I have tried this.

11.png

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

 

12.png

 

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

13.png

 

I also attached sample Power BI file here: Download:

 

Any help really appriciated!

Thanks a lot 

Community Support Team
Community Support Team

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

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.

10.JPG

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

 

Best Regards,

Lin

 

 

 

 

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Dhruvin Member
Member

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

Yes, You are right!

Thanks

Dhruvin Member
Member

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

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