Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Format dates in slicer not as expected

Hi,    I have a date dimension table D_DATE that contains the field BK_Date that contains a date. Its format is set to dd/MM/yyyy           In the facts table F_METRICS I have a calcul...
Need Help
Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

Can you please check the date format of your system/machine on which Power BI Desktop is installed?

I think your system date format is MM/DD/YYYY, therefore slicer is showing it that way in Power BI.

 

If this helps please give Kudos and mark it as a Solution! 🙂

 

Thanks,

Pragati

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks,

 

But my settings are correct, namely dd/MM/yyyy

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

R.W.

  • Pragati11's avatar
    Pragati11
    Icon for Super User rankSuper User
    6 years ago

    Hi Anonymous ,

     

    I see in your screenshot, that your Format = English(Belgium). Is this right? Does this need to be chnaged to United States or United Kingdom, etc.?

     

    Also, try checking in Power BI settings as follows:

    This should be same to your system date settings Region.

     

    If this helps please give Kudos and mark it as a Solution! 🙂

     

    Thanks,

    Pragati

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks,

       

      yes this is OK

      I'm working in Belgium, using Belgian key board, but all the applications are in English

      So English (Belgium) is correct

       

      I tried to change it to United States and in United Kingdom, but it doesnt have any effect: the dates in the slicer stay in the wrong format

       

      R.W.

       

      R.W.

      • Pragati11's avatar
        Pragati11
        Icon for Super User rankSuper User
        6 years ago

        HI Anonymous ,

         

        Does your Power BI settings also use "Belgium (English)" ??

         

        If this helps please give Kudos and mark it as a Solution! 🙂

         

        Thanks,

        Pragati