Forum Discussion
Date Format in Slicer
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..
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.
9 Replies
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 :D
Regards,
Salva.
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.
