Forum Discussion
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 that doesnt correspond to the format in filter.
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.
Regards
CS
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
4 Replies
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
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.
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