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

[krishna_murthy]

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 

[MasonMA]

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. 

[AnalyticPulse]

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 

[krishna_murthy]

@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
 

[AnalyticPulse]

@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.

[krishna_murthy]

@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 . 

[MasonMA]

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/1342...  

and Vote

https://community.fabric.microsoft.com/t5/Fabric-Ideas/Apply-date-format-quot-DD-MM-YYYY-quot-in-fil... 

[AnalyticPulse]

@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.

[krishna_murthy · Accepted solution]

@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.