Date Format in Slicer

[rocky09]

Is there any fix for this issue.  My Dataset date format is dd-mmm-yyyy and same in my PC Settings.  However, I am not able to control the date is Slicer.  It is always showing mm-dd-yyyy.

Any help is much appreciated..

[Salvador]

Hello,

Go to File > Options > Options and settings, then under Current File, Regional Settings. I use spanish locale, so that dates are shown in the format I need 😄

Regards,

Salva.

[rocky09]

@Salvador

Thank you.  It is working fine in Desktop version. But, once you published the report. The Format changes.

[Salvador]

Hello,

I dont currently use office 365, so I cant tell you the exact path, but you need to set up the "locale" for your account, it should be under your account settings, it probably has the english settings now.

[Thejeswar]

@Salvador, 

Somehow I feel this is not the right solution....

Since your locale settings, be it in desktop or in service (Account settings), is all limited only to the user who does that.

I.e. If you change in your system, your desktop will show the date in the format of your need. Similarly, when you change in account settings, it appears of your desired format only when you view the report.

So this means that when someone else is going to access the report, the date format is going to be the same as it is by default.

@rocky09,

So I would suggest that you go for this only if that report is dedicated for your use.

This is the reason why I don't feel this is the right solution and hence won't propose this as a solution when the report will be shared to others

[Salvador · Accepted solution]

Hello,

I had that issue on the previous company I worked for, Spanish company, but had the settings for british formating, so I had to change the default settings for most of the users, I'd say that's the issue here, since power bi is just using the user settings. 

One thing you could try, just for the slicers, is creating a calculated column, using Format function and "DD/MM/YYYY", I'd say it should work.

[mingyeh1979]

@Salvador 

I tried in my report but found if we converted the date format via Format function, it will prevent us from using between mode in Date Slicer (because data type changed to text instead of datetime?)

[rocky09]

Thank you @Salvador @Thejeswar for your replies.

for now, I have changed my Browswer Language Setting and it worked.

[Thejeswar]

Hi @rocky09,

In Slicer for data, if it is Slider showing such as Date Between, dates before and Dates After, the Data fomat is not responding to the format we select.

If the Slicer type is either a list or a drop down the format is displayed  similar to the way we have set it

[rocky09]

@Thejeswar

Thanks for your reply. So, you are saying that it is not possible to set the format when using Between/Before or After mode.