topic Re: how to change date format --- mm-dd-yyyy to dd-mm-yyyy in power bi in DAX Commands and Tips

how to change date format --- mm-dd-yyyy to dd-mm-yyyy in power bi

krishna_murthy — Thu, 16 Oct 2025 11:58:56 GMT

hi Team,

i have created dataflow and connected into the power bi now planning to change dateformat mm/dd/yyyy to dd/mm/yyyy in power bi , so i have tried in power query here the screenshot for your refrences
input is used it IST_system_order_time is mm/dd/yyyy and in power query itself converted format another yellow marked and here is showed required result but when i applied slicer it showing same way like mm/dd/yyyy

Where iam missing/ any missing / please check and let us know

Re: how to change date format --- mm-dd-yyyy to dd-mm-yyyy in power bi

AnalyticPulse — Thu, 16 Oct 2025 12:39:48 GMT

hi krishna_murthy

visuals use data model formatting which we set in data data view.. you can change it from column tools option.
let me know if this helps.

My Work:
Analytic Pulse Blog
Docynx Productivity Tools

Re: how to change date format --- mm-dd-yyyy to dd-mm-yyyy in power bi

krishna_murthy — Thu, 16 Oct 2025 13:14:06 GMT

AnalyticPulse ... thanks for quick response.
i have tried after your info and before raising the request also but no luck getting same format mm/dd/yyyy see below

i need this format dd/mm/yyyy

Re: how to change date format --- mm-dd-yyyy to dd-mm-yyyy in power bi

AnalyticPulse — Thu, 16 Oct 2025 14:01:02 GMT

krishna_murthy
there is format date option in properties of slicer visual which allows us to change the format of the date but apparently its not working hence i tried using format daxa function and created new column for desired format and its showing correctly ( you just have to change the datatype of the column.

Re: how to change date format --- mm-dd-yyyy to dd-mm-yyyy in power bi

MasonMA — Thu, 16 Oct 2025 15:24:41 GMT

Hi, I think this goes along with your Locale. If you must show the slicer in a specific format (e.g., DD-MM-YYYY) without adjusting the Locale I'd suggest creating calculated column with below DAX,

_Date = FORMAT('Date'[Date], "dd-MM-yyyy") and use this column for your slicer, but this way you may lose the Between display.

Re: how to change date format --- mm-dd-yyyy to dd-mm-yyyy in power bi

krishna_murthy — Thu, 16 Oct 2025 15:37:52 GMT

AnalyticPulse MasonMA ----
i have created calculated column and showing text format

trying to change datatype text to Date getting below error

If continue click yes then showing same mm/dd/yyyy format and also seen showing december 2025, but it should be oct 16 till today right .

Re: how to change date format --- mm-dd-yyyy to dd-mm-yyyy in power bi

AnalyticPulse — Thu, 16 Oct 2025 16:08:40 GMT

krishna_murthy what was the original datatype of the date column check at source level whether it was date or text. system is not recognizing date format correctly, apply format dax on the original column without changing date format in data view column tools option, you can try creating different date column for testing , this appears to be the source level datatypeissue.

Re: how to change date format --- mm-dd-yyyy to dd-mm-yyyy in power bi

MasonMA — Thu, 16 Oct 2025 17:17:41 GMT

Hi, i tested several times once again by adjusting Locale and Windows System regional setting. The Calendar format for 'Between' display on my slicer is fixed to dd/mm/yyyy and cannot be changed. My assumption is this might still be a bug.

Please refer to post

https://community.fabric.microsoft.com/t5/Desktop/Date-format-in-slicer-to-show-dd-mm-yyyy/td-p/1342209

and Vote

https://community.fabric.microsoft.com/t5/Fabric-Ideas/Apply-date-format-quot-DD-MM-YYYY-quot-in-filter-between/idi-p/4503472

Re: how to change date format --- mm-dd-yyyy to dd-mm-yyyy in power bi

krishna_murthy — Fri, 17 Oct 2025 03:19:24 GMT

AnalyticPulse MasonMA .... thanks for your quick support.
AnalyticPulse --- actually from the source original column datatype is TEXT, after that i have changed format in colum options.

I'm totally missed one update Actually my laptop time format is mm/dd/yyyy, hence in power bi slicer also showing same format.

Now changed the time format (dd/mm/yyyy) in my laptop and now looks good in power bi also.

once again thank you so much and sorry for that which i missed my laptop time format.