Forum Discussion
avitalo1
6 years agoFrequent 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.…
4 Replies
- amitchandakSuper 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
- avitalo1Frequent Visitor
Thanks for responding.
Attaching new screenshots - any ideas?
from the model view, for the column the slicer is based onthe slicer - with a better example
- Tahreem24Super User
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