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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
avitalo1
Frequent Visitor

Date formating

Date formatting question:
I would like to format my dates dd/mm/yyyy
My local settings are for Israel which uses dd/mm/yyyy, the formatting of the column in the data source is for my computer settings (the option with the *) But on my slicer I'm still getting the setting below mm/dd/yyyy
Any ideas? I would prefer even yyyy/mm/dd on the current situation.…96245023_3018035001575800_1726425807582134272_n.jpg
4 REPLIES 4
amitchandak
Super User
Super User

@avitalo1 , Can not tell with these dates unless the date is >12.

 

Anyway check the date format for the column. Check the format it should be dd/mm/yyyy

 

Data Format New Rib.png

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thanks for responding.

Attaching new screenshots - any ideas? 

 

from the model view, for the column the slicer is based onfrom the model view, for the column the slicer is based onthe slicer - with a better examplethe slicer - with a better example

@avitalo1 ,

 

Date range slicer setting are based on your system's date setting. Please refer simialar thread to tackle your issue:

https://community.powerbi.com/t5/Desktop/date-format-in-slicer/td-p/215627

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

As far as I can tell the regional settings of both my computer and the power BI are correct.  = English (Israel). 

Any ideas would be appreciated.

 

Avital

 

 

Annotation 2020-05-19 144038.png

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.