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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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

Top Kudoed Authors