Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Date Filter

Hi all, Any of you would know how to change the date format in a filter? Currently it is showing MM/DD/YYYY, I wanted it to be DD/MM/YYYY. I tried changing the format in modeling tab but tha...

amitchandak
6 years ago
DD/MM/YYYY format is a setting, please refer :https://community.powerbi.com/t5/Desktop/How-to-apply-UK-date-format-dd-mm-yyyy-in-Date-slicer/td-p/599712

Icon for Super User rank

Super User

6 years ago

DD/MM/YYYY format is a setting, please refer :https://community.powerbi.com/t5/Desktop/How-to-apply-UK-date-format-dd-mm-yyyy-in-Date-slicer/td-p/599712

Anonymous
Not applicable
6 years ago
Thank you! As I am using the app in citrix, i couldnt change the regiona setting. Is there any where else that i can change it? for example in power bi services etc?

Also, any easy way to show filter such that is is as of yesterday's date? of course in this case i want to show filter like above that start from 1/1/2018 but the to date should be as of yesterday. Everyday will be refresh and reflected on as of yesterday.
- amitchandak
  Super User
  6 years ago
  If your date is in MM/DD/YYYY, try changing the data format. Or create a new column like
  
  date new = format([date],"DD/MM/YYYY")
  
  For yesterday you can try relative date slicer. https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
- dax
  Community Support
  6 years ago
  Hi Anonymous ,
  
  As I know, the default value in slicer is not available currently, one workaround is that you could refer to power-bi-tutorial-dynamically-update-date-slicer-to-show-current-date for details.
  
  In addition, if you just want to show yesterday in date slicer, you could just create a calculated column like below
  
  Table = CALENDAR(date(2020,1,1), TODAY()-1)
  
  Best Regards,
  Zoe Zhi
  
  If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.