Date Filter

[Anonymous]

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

[amitchandak · Accepted solution]

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/...

[Anonymous]

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.

[dax]

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.

[amitchandak]

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