wrong date format in slicer

[fsim]

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.

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.

any idea would be appreciate 🙂

[Anonymous]

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

[fsim]

@Anonymous , that's my point !

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

[az38 · Accepted solution]

@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

[harshnathani]

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]

@harshnathani 

Hi ! I tried, no effect

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

[Greg_Deckler]

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