Forum Discussion

rocky09's avatar
rocky09
Solution Sage
7 years ago
Solved

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.   ...
Need Help
  • Salvador's avatar
    Salvador
    7 years ago

    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.

Salvador's avatar
Salvador
Responsive Resident
7 years ago

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.

rocky09's avatar
rocky09
Solution Sage
7 years ago

Thank you Salvador Thejeswar for your replies.

 

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