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
Super 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
    Super 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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Pragati11 

       

      Thanks,

       

      but it is

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      R.W.