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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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.


@ 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!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.