'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Power BI Slicer Ignoring dd/mm/yy Date Format
Question details
The user needs the Power BI Between slicer to correctly display dates in the dd/mm/yy format defined in their calendar table.
- Product
- Power BI
- Device & OS
- not provided
- Scenario
- Filtering report dates using the Between slicer style on a Power BI dashboard.
- Observed behavior
- The Between slicer style forces dates into the mm/dd/yy format, completely ignoring the dd/mm/yy custom formatting of the underlying Date column, even though other slicer styles display it correctly.
Verify that your operating system's regional date and time settings match your desired format, as the Power BI Between slicer relies heavily on local system settings rather than column formatting.
Modify Windows Regional Settings
Change your system's default date format, which the Power BI Between slicer inherits automatically.
Unlike other slicer styles in Power BI, the 'Between' date slicer natively relies on your operating system's regional settings rather than the custom format applied directly to your data model column. Adjusting your Windows region settings often resolves this display issue.
Press the Windows key, type 'Control Panel', and open the application. Navigate to 'Clock and Region' and click on 'Region'.
In the Region dialog, under the 'Formats' tab, ensure the 'Format' dropdown is set to a locale that inherently uses dd/mm/yy, such as English (United Kingdom).
Apply the new settings, close the dialog, and completely restart Power BI Desktop for the new regional format to take effect on your Between slicer.
Consult the Microsoft Fabric Community
Check for official patches, advanced workarounds, or confirm current product behavior with Microsoft engineers.
Manage Data and Formats Seamlessly with WPS Office
If you frequently encounter rigid formatting limitations in complex data tools, consider using WPS Spreadsheet for your daily data processing and charting. It perfectly respects your custom date formats and offers a highly compatible alternative to Microsoft Office.
- 1. Download and Install: Get WPS Office for free from the official website and install it on your computer.
- 2. Open Your Dataset: Launch WPS Spreadsheet and open your existing Excel or CSV data files with a single click.
- 3. Apply Custom Date Formats: Select your date cells, right-click, choose 'Format Cells', and easily define your exact dd/mm/yy parameters.
Frequently Asked Questions
Why does only the Between slicer ignore my dd/mm/yy format?
The Between slicer in Power BI relies on a built-in date picker control which inherently pulls its formatting from the user's browser or operating system's local regional settings, entirely bypassing the custom column formatting defined in your Power BI data model.
Does changing the locale in Power BI settings fix the Between slicer?
Changing the 'Locale for import' in Power BI Desktop settings affects how data is parsed during the import phase, but it does not change how the Between slicer renders the date visually. The visual slicer relies on the Windows OS regional formats.
Are there other slicer styles in Power BI that respect custom date formats?
Yes. If you switch your date slicer from the 'Between' style to a 'List' or 'Dropdown' style using the formatting pane, Power BI will correctly display the custom dd/mm/yy format exactly as you configured it in the underlying Date column.
