how to change date format from mm/dd/yyyy to dd/mm/yyyy in slicer between function

[karthik77700]

I was using slicer between function but this is not converting date format to dd/mm/yyyy .Column is in dd/mm/yyyy format only and in desktop i have changed setting locale to United kingdom time but still in Power BI service its showing as mm/dd/yyyy format only.

[Sergii24 · Accepted solution]

Hi, @karthik77700, Power BI date formatting in Power BI Sevice follows your browser default settings (if else is not specified). This article should help you - Manage Date Formats in the Power BI Service - MSSQLTips.com

Good luck with your project 🙂 

[bhanu_gautam]

@karthik77700 ,

Check Regional Settings in Power BI Service:

Go to the Power BI Service.
Click on the gear icon (⚙️) in the top right corner and select "Settings."
Under "Settings," go to the "Regional Settings" tab.
Ensure that the "Locale" is set to "English (United Kingdom)."
Ensure Column Data Type is Date:

In Power BI Desktop, make sure that the column data type is set to "Date" or "Date/Time."
You can do this by selecting the column in the Data view and then setting the Data type in the Column tools.
Format Date Column in Power BI Desktop:

In Power BI Desktop, select the date column.
Go to the "Modeling" tab and click on "Format."
Choose the desired date format (e.g., dd/MM/yyyy).
Publish and Refresh:

After making these changes, publish your report to the Power BI Service again.
Ensure that the dataset is refreshed in the Power BI Service.

FormattedDate = FORMAT([YourDateColumn], "dd/MM/yyyy")