Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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

7 REPLIES 7
itsme007
Frequent Visitor

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
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.

Yes, You are right!

Thanks

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.