Forum Discussion
Date Filter
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.
Super UserIf 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