Forum Discussion
Date Slicer 'Between' - Issue with Date Format when published.
Hi VijayRbn ,
Base on your description, it appears there is an issue with the date format display within the slicers. For clarity, it’s important to note that the date format display within Power BI Desktop is contingent upon your computer’s region settings.
In order to gain a comprehensive understanding of your problem and make further troubleshooting, could you kindly provide the following information? Are the fields which applied on the slicers in the below screenshot from the same date field of one same table?I can reproduce your problem. You can create a new calculated column as below and apply it on the between, before and after slicer.
DisplayDate = FORMAT([Date], "dd/mm/yyyy")In Power BI DesktopIn Power BI Service
Best Regards
Thank you @v-yiruan-msft for your effort on this. To your question, yes this is all one field from one table.
But what I am trying in my report is, I want to see the dates irrespective of what is local settings. So I am selecting a date format which is US English Format (m/d/yyyy), which is should enforce local settings to what is defined in the report.
If I select the formats with * then the report should supposed to respect local setting/browser setting.
In my case, even if I select the format (m/d/yyyy) as highlighted above, which is not enforcing the report to show US format, instead it respects broswer setting/local setting, which should not be the case.
So, can you please check if you set the date format for that date field to (m/d/yyyy) and check if the between slicer shows the US format as it should based on report setting or is it showing UK format based on your local settings.
