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.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 281 members 2,976 guests
Please welcome our newest community members: