Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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/...
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/...
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.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |