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

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

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
Resident Rockstar
Resident Rockstar

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 and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.