Forum Discussion
SUN_19
2 years agoFrequent Visitor
Calendar filter format
Created 1 calendar filter in the report. Report is working fine with filter. But I need to change the format of the calendar from MM/DD/YYYY to DD/MM/YYYY . I changed the date format to DD/MM/YYYY in the field date. But not reflecting in the filter.Please advise
4 Replies
- SUN_19Frequent Visitor
Thank you for your reply.
I already changed . But still not working.
- LeonardoCSilvaFrequent Visitor
I think that your Power BI is using the english format os date. Try to chagend using locality.
> Open Power Query
> Click with de right bottom on column date> Transform
> Transform using locality> Try to change for Brazil (becouse Brazil utilize the form dd/mm/yyyy
- FowmySuper User
SUN_19
Please refer tgis solution :
https://community.fabric.microsoft.com/t5/Desktop/date-format-in-slicer/m-p/215627