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

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
fsim
Responsive Resident
Responsive Resident

wrong date format in slicer

Hi all !

 

I just noticed this (at least from the  July version) Whatever option I select about regional setings, date in slicers showed up in US format. 

My computer is set to English(Belgium) regional settings, Date should be shown as dd/mm/yy . 

In fact it works in dropdown or list slicer. Not in the other options as you can see below.

 

Annotation 2020-08-17 142517.png

 

fun fact one of my colleague has the same issue.

I don't have it on my personnal computer where the regional settings are set to french(belgium). I double check the two regional settings option in power bi desktop and they are all the same.

 

Annotation 2020-08-17 150901.png

 

any idea would be appreciate 🙂

 

1 ACCEPTED SOLUTION
az38
Community Champion
Community Champion

@fsim 

I think, unfortunately, all you can do now is to support appropriate idea here https://ideas.powerbi.com/ideas/idea/?ideaid=259584ec-e3cd-441c-8380-6ccd88abc364


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

6 REPLIES 6
V-pazhen-msft
Community Support
Community Support

@fsim 

There is not way to edit the format in Between, before and after slicer. It can only displays date in the default format. 


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

@V-pazhen-msft , that's my point !

the default format is NOT the one the slicer is using 😕

 

az38
Community Champion
Community Champion

@fsim 

I think, unfortunately, all you can do now is to support appropriate idea here https://ideas.powerbi.com/ideas/idea/?ideaid=259584ec-e3cd-441c-8380-6ccd88abc364


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn
harshnathani
Community Champion
Community Champion

Hi @fsim ,

 

 

Try changing the date formats using Locale in Power Query.

 

https://www.oraylis.de/blog/local-date-formats-in-power-bi#:~:text=In%20the%20query%20editor%20you,s...

 

 

Regards,

Harsh Nathani

 

fsim
Responsive Resident
Responsive Resident

@harshnathani 

Hi ! I tried, no effect

the format is good everywere BUT in the between (before or later) slicer

 

@fsim - I believe this has come up before and there really isn't a way to control the way the date is displayed in that format of the slicer.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.