cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dhruvin
Helper III
Helper III

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
v-lili6-msft
Community Support
Community Support

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.

View solution in original post

6 REPLIES 6
Dhruvin
Helper III
Helper III

@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
Community Support
Community Support

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.

View solution in original post

Yes, You are right!

Thanks

reza_rad
MVP

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

Author, Consultant, Speaker
https://radacad.com

@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 

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors