Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
SUN_19
Frequent 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 4
Fowmy
Super User
Super User

@SUN_19 

Please refer tgis solution : 
https://community.fabric.microsoft.com/t5/Desktop/date-format-in-slicer/m-p/215627

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Dangar332
Super User
Super User

Hi, @SUN_19 

change format from column tool
1. select your column(right click) it open column tool
from that change it to DD/MM/YYY.

 

like below image 

Dangar332_0-1703758527846.png

 

Thank you for your reply.

SUN_19_0-1703761386041.png

I already changed . But still not working.

 

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

Helpful resources

Announcements
FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.