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
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!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

Top Solution Authors